JohnOmernik / sqlalchemy-drill

Apache Drill Dialect for SQL Alchemy
Other
53 stars 35 forks source link

Metadata enhancements #20

Closed cgivre closed 5 years ago

cgivre commented 5 years ago

This PR adds a lot of functionality to superset. As of Drill 1.15, Drill includes column metadata in the REST interface as well as improvements to the INFORMATION_SCHEMA. The specific improvements allow you to use SQL Lab in Superset. See images below:

Picking a Storage Plugin

In SQL Lab you can pick from the available and enabled storage plugins:

screen shot 2019-01-07 at 14 41 22

Select a File or Schema

Once you've selected the schema, Superset will load the available files and populate the dropdown menu.

screen shot 2019-01-07 at 14 47 28

Once you've done that, you can see that Superset will read the columns and their associated data types as shown in the image below:

screen shot 2019-01-07 at 14 48 40

Additionally, you can preview the file or table structure:

screen shot 2019-01-07 at 14 51 01

Not only that, but it enables type ahead!!

screen shot 2019-01-07 at 14 51 16