SQL Model
The semantic model itself does not distinguish specific implementation syntax, but the data and behavior of the semantic model may differ when implemented with different syntaxes. Below are some considerations for SQL implementations.
Data Tables
The Data Tables area of the SQL model contains data lists sourced from the database's metadata.
The Data Catalog configured in the semantic model corresponds to the Schema or Database to which the physical tables in the database belong.
For example, in StarRocks, the service catalog corresponds to its database (using SHOW DATABASES to list all database instances).
For a Postgres database, the service catalog corresponds to its Schema (using the SELECT schema_name FROM information_schema.schemata statement to query all Schemas).
Similarly, the source of table name descriptions varies across different database systems. In MySQL, descriptive text for tables or fields is implemented using the COMMENT keyword, while in Postgres, it is done using the COMMENT ON command.
Access Control
Currently, the SQL version of the semantic model does not support row-level data access control.
Virtual Multidimensional Cubes
Currently, the SQL version of the semantic model does not support the virtual multidimensional cube feature.
If you find any issues with this product or have feature requests, please submit them on the https://github.com/meta-d/meta-d/issues page.