SQLMDX - Application Security

The security of your data is critical.

Metadata is information that describes data but is not the data itself. The metadata describes the table and the columns and the type of data in that column but is not the actual data. Metadata describes the column as varchar(10) but nothing about the values stored in that column.

When pulling metadata from the source server your tables are never directly queried. The application only selects from the metadata views provided by the server. You have full access to all sql statements before they are executed.

When pushing schema to Snowflake your snowflake tables are never queried. Data from the first step is PUT on a snowflake stage and tables are created. The native application requires no permissions.