# Guides

- [How to Guides (UI)](/guides/how-to-guides-ui.md)
- [Creating & Configuring Data Sources](/guides/how-to-guides-ui/creating-and-configuring-data-sources.md)
- [How to Create a Data Source for Data Streamed from Kafka](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-create-a-data-source-for-data-streamed-from-kafka.md): Create a data source for data streamed from Kafka in DataPancake.
- [How to Configure Materialization & Dynamic Table Settings](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-output-object-and-dynamic-table-settings.md): Configure Output Object Settings, Dynamic Table Settings, and Dynamic Table Metadata Settings for a data source.
- [How to Configure the Secure View Layer](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-the-secure-semantic-view-layer.md): Configure the Semantic Layer Settings for a data source.
- [How to Configure Schema Filters](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-schema-filters.md): Configure Schema Filters for a data source.
- [How to Configure a Data Source for a Single Semi-Structured Data Column in a Table or View](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-a-data-source-for-a-single-semi-structured-data-column-in-a-table-or-view.md): Configure a table or view data source for semi-structured data.
- [How to Configure a Data Source for a Structured Table or View](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-a-data-source-for-a-structured-table-or-view.md): Configure a table or view data source for structured data.
- [How to Configure an External Table Data Source (JSON Only)](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-an-external-table-data-source-json-only.md): Configure an External Table data source.
- [How to Configure an Iceberg Data Source (JSON Only)](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-an-iceberg-data-source-json-only.md): Configure an Iceberg data source.
- [How to Modify the Schema](/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-modify-the-schema.md)
- [Modify Enabled Features for a Data Source](/guides/how-to-guides-ui/modify-enabled-features-for-a-data-source.md): Enable or disable the Pipeline Designer, SQL Code Generation, Security Policy Integration, Data Dictionary Builder, and Semantic Model Generator as needed for each data source.
- [How to Scan the Data Source](/guides/how-to-guides-ui/how-to-scan-the-data-source.md)
- [Pipeline Designer](/guides/how-to-guides-ui/pipeline-designer.md)
- [How to Create Virtual Attributes](/guides/how-to-guides-ui/pipeline-designer/how-to-create-virtual-attributes.md)
- [How to Add Column Materialization Rules](/guides/how-to-guides-ui/pipeline-designer/how-to-add-column-materialization-rules.md)
- [How to Apply Column-Level Schema Transformations](/guides/how-to-guides-ui/pipeline-designer/how-to-apply-column-level-schema-transformations.md)
- [How to Merge Polymorphic Attribute Versions](/guides/how-to-guides-ui/pipeline-designer/how-to-merge-polymorphic-attribute-versions.md): This feature allows you to automatically merge all numeric attributes into either the float or string polymorphic version of the attribute by creating a sql expression and an alias.
- [How to Add Aliases](/guides/how-to-guides-ui/pipeline-designer/how-to-add-aliases.md)
- [How to Configure Array Relationships \[Coming Soon\]](/guides/how-to-guides-ui/pipeline-designer/how-to-configure-array-relationships-coming-soon.md)
- [How to Configure Security Policies](/guides/how-to-guides-ui/pipeline-designer/how-to-configure-security-policies.md)
- [How to Configure Foreign Keys](/guides/how-to-guides-ui/pipeline-designer/how-to-configure-foreign-keys.md)
- [How to Generate Dynamic SQL Statement Code](/guides/how-to-guides-ui/pipeline-designer/how-to-generate-dynamic-sql-statement-code.md)
- [Data Dictionary Builder](/guides/how-to-guides-ui/data-dictionary-builder.md)
- [How to Generate a Data Source Description](/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-a-data-source-description.md)
- [How to Generate Array Descriptions & Synonyms](/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-array-descriptions-and-synonyms.md)
- [How to Generate Attribute Descriptions, Synonyms, & Sample Values](/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-attribute-descriptions-synonyms-and-sample-values.md)
- [How to Deploy & Validate Generated Code](/guides/how-to-guides-ui/how-to-deploy-and-validate-generated-code.md)
- [How to Guides (Script Builder)](/guides/how-to-guides-script-builder.md)
- [Admin Guides](/guides/how-to-guides-script-builder/admin-guides.md)
- [How to Grant Account Level Privileges to DataPancake](/guides/how-to-guides-script-builder/admin-guides/how-to-grant-account-level-privileges-to-datapancake.md): Build a script to grant DataPancake the necessary account-level and Cortex AI privileges required for scanning and schema discovery the Cortex AI assisted data dictionary builder.
- [How to Configure Available Warehouses in DataPancake](/guides/how-to-guides-script-builder/admin-guides/how-to-configure-available-warehouses-in-datapancake.md): Build a script to configure virtual warehouse access for DataPancake by granting usage on existing warehouses or provisioning new, optimized warehouses for scanning and discovery workloads.
- [How to Manage Access to DataPancake](/guides/how-to-guides-script-builder/admin-guides/how-to-manage-access-to-datapancake.md): To allow additional users to access DataPancake, you can grant the APP\_PUBLIC application role to any existing system or custom role in your Snowflake account.
- [Data Source Guides](/guides/how-to-guides-script-builder/data-source-guides.md)
- [How to Create a Single DataPancake Data Source (Script Builder)](/guides/how-to-guides-script-builder/data-source-guides/how-to-create-a-single-datapancake-data-source-script-builder.md): Build a script to create and initiate a scan for a single data source in DataPancake and optionally generate SQL code.
- [Alert Guides](/guides/how-to-guides-script-builder/alert-guides.md)
- [How to Create Schema Drift Alerts (Script Builder)](/guides/how-to-guides-script-builder/alert-guides/how-to-create-schema-drift-alerts-script-builder.md): Build a script to create schema drift email alerts for all connected data sources in DataPancake.
- [How to Guides (Bulk Upsert via CSV)](/guides/how-to-guides-bulk-upsert-via-csv.md)
- [Database Object Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization.md)
- [Core Attributes - Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/core-attributes-initialization.md): Create a new stage and upload the stored procedure to enable bulk updates for core attribute metadata.
- [Core + Security Attributes - Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/core-+-security-attributes-initialization.md): Create a new stage and upload the stored procedure to enable bulk updates for both core and security attribute metadata.
- [Core + Data Dictionary Attributes - Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/core-+-data-dictionary-attributes-initialization.md): Select a stage and upload the stored procedure to enable bulk updates for both core and data dictionary attribute metadata or to generate descriptions, synonyms, and sample values via Cortex AI.
- [Datasource Metadata - Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/datasource-metadata-initialization.md): Select a stage and upload the stored procedure to enable bulk updates for datasource metadata.
- [Array Foreign Key - Initialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/array-foreign-key-initialization.md): Select a stage and upload the stored procedure to enable bulk updates for array foreign key metadata metadata.
- [Schema Transformation / Consolidation - Intialization](/guides/how-to-guides-bulk-upsert-via-csv/database-object-initialization/schema-transformation-consolidation-intialization.md): Select a stage and upload the stored procedure to enable bulk updates for schema transformation metadata.
- [Usage](/guides/how-to-guides-bulk-upsert-via-csv/usage.md)
- [Core Attributes - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/core-attributes-bulk-update.md): Select and export the attribute metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then perform a bulk update for core attribute metadata in DataPancake.
- [Core + Security Attributes - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/core-+-security-attributes-bulk-update.md): Select and export the attribute metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then perform a bulk update for core and security attribute metadata in DataPancake.
- [Core + Data Dictionary Attributes - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/core-+-data-dictionary-attributes-bulk-update.md): Export the attribute metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then use to perform a bulk update on core & data dictionary attribute metadata in DataPancake.
- [Datasources - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/datasources-bulk-update.md): Select and export the datasource metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then perform a bulk update in DataPancake.
- [Array Foreign Key - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/array-foreign-key-bulk-update.md): Select and export the array foreign key metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then perform a bulk update in DataPancake.
- [Schema Transformation / Consolidation - Bulk Update](/guides/how-to-guides-bulk-upsert-via-csv/usage/schema-transformation-consolidation-bulk-update.md): Select and export the scema transformation metadata to a .csv file, edit in a spreadsheet like Google Sheets or Excel, then perform a bulk update in DataPancake.
- [Miscellaneous Guides](/guides/miscellaneous-guides.md)
- [How to Install DataPancake](/guides/miscellaneous-guides/how-to-install-datapancake.md): Purchase and Install the DataPancake Snowflake Native App into an existing Snowflake account.
- [How to Upgrade DataPancake from the Free Trial](/guides/miscellaneous-guides/how-to-upgrade-datapancake-from-the-free-trial.md): Upgrade DataPancake from a free trial to use all of its features.
- [JSON Tutorial UDFs & Security Policies](/guides/miscellaneous-guides/json-tutorial-udfs-and-security-policies.md): Copy and deploy these in a workspace for the JSON Tutorial.
- [FAQ](/guides/faq.md): Frequently Asked Questions