Data Gateway component is providing users with ability to share selected tables from storage in read-only mode with external tools and users. Among main use cases belongs accessing data from 3rd party BI tools (Tableau, Looker, GoodData etc.).
- Project needs to be using Snowflake backend, as the component is using Snowflake Reader Account functionality for data provisioning.
- Any 3rd party tool accessing the data needs to support Snowflake Key Pair authentication method.
| Feature | Description |
|---|---|
| Row-Based Configuration | Allows structuring the configuration in rows. |
| Key Pair Generator | Component automatically generates Key Pair for acessing the data. |
| Copy/Clone Full Load Types | Allows two full load modes, where copy allows data types conversion. |
Set up credentials for accessing the data from the external tools.
Firstly, the component generates Key Pair, which will be used for authentication. The Private Key is automatically downloaded (based on user's browser settings) and not stored after that anywhere for enhanced security. If the user doesn't download the Private Key immediately, they can initiate the download by clicking the Download Private Key button before they initiate Workspace creation. If user needs to access Private Key later on, they need to regenerate the whole Key Pair.
Once user Create Read-Only Workspace, the generated Public Key is automatically assigned to the database user with privileges to access the data in the read-only workspace and user is provided with all necessary credentials to connect via any tool supporting Snowflake Key Pair database connection. These credentials are later on accessible by clicking on Database credentials in the right menu.
After the credentials are privisioned, user can add any tables from the storage to be shared through Data Gateway in read-only mode.
When using Full Load (Copy) load type, user can change names of the columns and their data type before loading them to read-only workspace.
Running the component will load all selected tables to the read-only workspace, providing mirrored version of the data in the user's storage.
