Skip to content

Files

Latest commit

6bb1247 · Aug 7, 2021

History

History
55 lines (38 loc) · 1.4 KB

01_setup_database_datasets.md

File metadata and controls

55 lines (38 loc) · 1.4 KB

Superset - 01 Setup the database and datasets

Go to http://localhost:8088/ and connect using admin credentials admin / admin

Create a new Database with the following configuration :

  • BASIC / DISPLAY NAME : MongoBI
  • BASIC / SQLALCHEMY URI : mongobi://root?source=admin:root@poc_ssm_mongo_bi:3307/samples

  • ADVANCED / OTHER / EXTRA :
{
  "metadata_params": {},
  "engine_params": {
    "connect_args": {
        "ssl": {
            "mode": "PREFERRED"
        }
    }
  },
  "metadata_cache_timeout": {},
  "schemas_allowed_for_csv_upload": [] 
}

Create a new dataset for the table companies in the samples database of the previously created MongoBI superset database.

  • DATASOURCE : MongoBI
  • SCHEMA : samples
  • TABLE : companies

Create another new dataset for the table companies_office in the samples database of the previously created MongoBI superset database.

  • DATASOURCE : MongoBI
  • SCHEMA : samples
  • TABLE : companies_offices

Create another new dataset for the table tweets in the samples database of the previously created MongoBI superset database.

  • DATASOURCE : MongoBI
  • SCHEMA : samples
  • TABLE : tweets

**Next we are going to create a simple bar chart