How to Configure a Data Source for a Single Semi-Structured Data Column in a Table or View

Configure a table or view data source for semi-structured data.

1. Navigate to the Data Sources page

2. Enter the Data Source name

3. Select Semi-Structured for the Data Source Type

4. Enter any data source tags

These are DataPancake tags for DataPancake data sources, not Snowflake tags.

5. Select the Object type (Table, View, or Materialized View)

See the documentation for External Tables or Iceberg Tables for creating additional types of data sources.

6. Select the Column Data Type

7. Select the Format Type

8. Select the Database

9. Select the Schema

10. Select the Object Name

11. Enter the Column Name

Use uppercase, otherwise use "double quotes" to encapsulate the column name if it is case sensitive.

12. (Optional) Enter Sample Schema Data

13. Ensure all required fields are completed

The "Required Fields" section in the bottom of the left-hand sidebar will show exactly which fields must still be completed.

If code generation feature is enabled, see How to Configure the Secure Semantic View Layer.

14. Save the data source (unless the code generation feature has been selected)

If the code generation feature is enabled, you must complete the Output Object & Dynamic Table Settings before you can save.

---

Next Steps

How to Modify Enabled Features for a Data Source

How to Configure the Secure Semantic View Layer

Pipeline Designer (WIP)

Data Dictionary Builder (WIP)

Semantic Model Generator (WIP)