# How to Guides (UI)

- [Creating & Configuring Data Sources](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources.md)
- [How to Create a Data Source for Data Streamed from Kafka](https://docs.datapancake.com/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](https://docs.datapancake.com/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](https://docs.datapancake.com/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](https://docs.datapancake.com/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](https://docs.datapancake.com/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](https://docs.datapancake.com/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)](https://docs.datapancake.com/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)](https://docs.datapancake.com/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 Manage a Scan Configuration](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-manage-a-scan-configuration.md): Create or modify a scan configuration for a data source.
- [Page](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/page.md)
- [How to Configure Schema Consolidation](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-schema-consolidation.md): Configure Schema Consolidation for a data source.
- [How to Configure Baseline Scan Settings](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-configure-baseline-scan-settings.md): Configure Baseline Scan Settings for a data source.
- [How to Modify the Schema](https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-modify-the-schema.md)
- [Modify Enabled Features for a Data Source](https://docs.datapancake.com/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](https://docs.datapancake.com/guides/how-to-guides-ui/how-to-scan-the-data-source.md)
- [Pipeline Designer](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer.md)
- [How to Create Virtual Attributes](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-create-virtual-attributes.md)
- [How to Add Column Materialization Rules](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-add-column-materialization-rules.md)
- [How to Apply Column-Level Schema Transformations](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-apply-column-level-schema-transformations.md)
- [How to Merge Polymorphic Attribute Versions](https://docs.datapancake.com/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](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-add-aliases.md)
- [How to Configure Array Relationships \[Coming Soon\]](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-configure-array-relationships-coming-soon.md)
- [How to Configure Security Policies](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-configure-security-policies.md)
- [How to Configure Foreign Keys](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-configure-foreign-keys.md)
- [How to Generate Dynamic SQL Statement Code](https://docs.datapancake.com/guides/how-to-guides-ui/pipeline-designer/how-to-generate-dynamic-sql-statement-code.md)
- [Data Dictionary Builder](https://docs.datapancake.com/guides/how-to-guides-ui/data-dictionary-builder.md)
- [How to Generate a Data Source Description](https://docs.datapancake.com/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-a-data-source-description.md)
- [How to Generate Array Descriptions & Synonyms](https://docs.datapancake.com/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-array-descriptions-and-synonyms.md)
- [How to Generate Attribute Descriptions, Synonyms, & Sample Values](https://docs.datapancake.com/guides/how-to-guides-ui/data-dictionary-builder/how-to-generate-attribute-descriptions-synonyms-and-sample-values.md)
- [How to Deploy & Validate Generated Code](https://docs.datapancake.com/guides/how-to-guides-ui/how-to-deploy-and-validate-generated-code.md)
- [Data Dictionary](https://docs.datapancake.com/guides/how-to-guides-ui/data-dictionary.md)
- [Semantic Model Generator](https://docs.datapancake.com/guides/how-to-guides-ui/semantic-model-generator.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.datapancake.com/guides/how-to-guides-ui.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
