Incubator-superset: Tutorial error in creating new table and no information on how to create new table

[QiXuanWang]

Superset version

latest develop version

Expected results

New table "testTable" created

Actual results

Table [testTable] could not be found, please double check your database connection, schema, and table name

Stack:
  File "/usr/local/lib/python2.7/dist-packages/superset/models.py", line 1176, i                   n get_sqla_table_object
    return self.database.get_table(self.table_name, schema=self.schema)
  File "/usr/local/lib/python2.7/dist-packages/superset/models.py", line 835, in                    get_table
    autoload_with=self.get_sqla_engine())
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4                   16, in __new__
    metadata._remove_table(name, schema)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py",                    line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4                   11, in __new__
    table._init(name, metadata, *args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4                   84, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4                   96, in _autoload
    self, include_columns, exclude_columns
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line                    1972, in run_callable
    return conn.run_callable(callable_, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line                    1477, in run_callable
    return callable_(self, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", li                   ne 364, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py",                    line 571, in reflecttable
    raise exc.NoSuchTableError(table.name)
NoSuchTableError: testTable

Steps to reproduce

In your tutorial:
"
Once your database has been added, it’s time to add your table. Navigate using the navigation bar at the top to Sources -> Tables and click the plus (+) sign there (similar to the one ).
ow enter the name of the table in the Table Name textbox, and select the database you just created in the Database dropdown, hit save. At this moment, Superset fetched the column names, their data types and tries to guess which fields are metrics in dimensions
"
Follow this step and use "testTable" as new table name. All others not touched.

[xrmx]

Do you have a testTable in your database? If not the tutorial is correct. Tables are added to superset metadata, they are not created in the database.

[QiXuanWang]

I don't have testTable in database. I guess your're right. So do you mean that these tables should be created out side of superset? Like I should have another program that creates this database and using superset to view those data? If so, please close this issue.

[xrmx]

Yes, superset is for exploring and visualizing data you already have.

[QiXuanWang]

Thanks. Please add one comment in tutorial so it would be clear. My original thought is that you can create .db by URI, I would expect tables could be created too but yes, it's not like that. One sentence would save some efforts though :)

[HUMPHREY94]

Sorry me i have already created database and its table, but i have no created a schema yet, i try ,to connect that table but its bring the error

Table [students] could not be found, please double check your database connection, schema, and table name

[EeshanChatterjee]

Same error. Test connection shows up the tables, but add tables (with public schema, admin user) throws the error: Table [sh_events] could not be found, please double check your database connection, schema, and table name

[RABEB2]

Same error. Test connection shows up the tables, but add tables (with public schema, admin user) throws the error: Table [sh_events] could not be found, please double check your database connection, schema, and table name

i got the same error please have u got found a solution for it please ?

[stardev24]

@xrmx
Getting Table[trail] could not be found error even after creating table, Schema and database connection.
Please help us to fix this issue.

[anurag-priyadarshi]

@EeshanChatterjee @stardev24 were you able to fix this?