Version 2021

Catalog for a List of Tables

The following query is for a list of tables:

Copy 
SELECT DISTINCT TABLE_SCHEMA as NAME_SPACE, TABLE_NAME as TAB_NAME from INFORMATION_SCHEMA.TABLES 

You can modify the default SQL query using Workstation, Web, or Developer. This setting has a different impact depending on where it is located, as explained further below.

Catalog for Columns in a Table via Developer 

Modify the default SQL statement to retrieve tables as shown below. Changes to the default SQL statement impact column retrieval for the project schema. 

Catalog for a List of Tables via Workstation or Web

  1. In Workstation or Web, configure the catalog option in the data import. Workstation must be in server mode.

     

  2. Under Retrieval Mode, select Data source SQL to allows the default SQL statement to retrieve tables available in the data source. Changes to the SQL statement impact column for data import. 

  3. Select ODBC calls to retrieve namespaces and tables. 

  4. MicroStrategy provide caching for tables and columns. You can cache table or column names. Tables names are cached by default. MicroStrategy cannot guarantee caching when using non-default SQL.