Manage Data Source

From the Manage Data Source page, users can view and modify information about data sources in Pancake.

Note that, while you can add a data source to Pancake through the Manage Data Source Page, you will still need to grant usage through a worksheet on every data source you wish to make available to the app with statements similar to the following:

GRANT USAGE ON DATABASE <database_name> TO APPLICATION PANCAKE;
GRANT USAGE ON SCHEMA <database_name>.<schema_name> TO APPLICATION PANCAKE;

If you are editing an existing data source, make a selection from the "Select a data source to edit" dropdown. If you are adding a new data source, begin filling out the Data Source Settings section.

Data Source Settings

When adding data sources from a worksheet, Pancake uses a default naming convention consisting of <database>.<schema>.<json_object>, users are able to edit the name in the Data Source Name field.

The Status field indicates the status of the data source object in Pancake, not the status of the data source in your environement. It can be set to Active, Inactive, or Deleted. If you wish to "remove" a data source from Pancake be sure to set this to Deleted.

Users can add whatever tags they like for a data source in the Tags field.

Connection Status indicates the current state of data source availability.

Product Tier

The Product Tier section will only display the Change Product Tier button initially, meaning the currently selected data source is on the Schema Summary tier. Click the Change Product Tier button to upgrade the data source to Schema Summary or Dynamic Table Generation.

Note that Schema Analysis and Dynamic Table Generation are not selectable unless you have upgraded the app though the Pancake listing in the Snowflake Marketplace.

Data Object Settings

In the Data Object Setting section you must set the data source object type, format type, and input the database name, schema name, object name, and column name before you can add the source to Pancake.

Updating a Data Source

After selecting an existing data source from the dropdown, all the fields on this page will be filled out. These fields are user editable, but be aware that altering data source or object settings could impact the connection status of the data source.