# Propel docs

## Docs

- [Access Policies](https://www.propeldata.com/docs/access-policies.md): Fine-grained control over Data Pool access with column and row-level rules
- [Applications](https://www.propeldata.com/docs/applications.md): SQL and API credentials.
- [Architecture](https://www.propeldata.com/docs/architecture.md): Learn about Propel's cloud-native ClickHouse® architecture.
- [2022 Changelog](https://www.propeldata.com/docs/changelog/2022.md): New features, fixes, and improvements.
- [2023 Changelog](https://www.propeldata.com/docs/changelog/2023.md): New features, fixes, and improvements.
- [2024 Changelog](https://www.propeldata.com/docs/changelog/2024.md): New features, fixes, and improvements.
- [Changing schemas](https://www.propeldata.com/docs/changing-schemas.md): Schema changes in ClickHouse.
- [Connect & SDKs](https://www.propeldata.com/docs/connect.md): Connect using ClickHouse or PostgreSQL clients and SDKs.
- [Creating tables](https://www.propeldata.com/docs/creating-tables.md): Create Data Pools via the API or Terraform.
- [Deleting data](https://www.propeldata.com/docs/deleting-data.md): Real-time and batch deletes in ClickHouse.
- [Authentication](https://www.propeldata.com/docs/embeddable-ui/authentication.md): Manage authentication across components.
- [AccessToken Provider](https://www.propeldata.com/docs/embeddable-ui/components/access-token-provider.md): Manage authentication across components.
- [Counter](https://www.propeldata.com/docs/embeddable-ui/components/counter.md): Visualize a counter value.
- [Data Grid](https://www.propeldata.com/docs/embeddable-ui/components/data-grid.md): Visualize records in table format.
- [Filter provider](https://www.propeldata.com/docs/embeddable-ui/components/filter-provider.md): Applies filters to child components.
- [Group By](https://www.propeldata.com/docs/embeddable-ui/components/group-by.md): Break down data by dimensions.
- [Leaderboard](https://www.propeldata.com/docs/embeddable-ui/components/leaderboard.md): Display ranked aggregate data.
- [Log provider](https://www.propeldata.com/docs/embeddable-ui/components/log-provider.md): Customize error logging.
- [Pie Chart](https://www.propeldata.com/docs/embeddable-ui/components/pie-chart.md): Show part-to-whole relationships.
- [Simple Filter](https://www.propeldata.com/docs/embeddable-ui/components/simple-filter.md): Filter data using a dropdown.
- [Theme provider](https://www.propeldata.com/docs/embeddable-ui/components/theme-provider.md): Customize the look and feel of your UI.
- [Time Grain Picker](https://www.propeldata.com/docs/embeddable-ui/components/time-grain-picker.md): Choose a time granularity for aggregation.
- [Time Range Picker](https://www.propeldata.com/docs/embeddable-ui/components/time-range-picker.md): Select date ranges for analysis.
- [Time Series](https://www.propeldata.com/docs/embeddable-ui/components/time-series.md): Visualize time-series data.
- [useCounter](https://www.propeldata.com/docs/embeddable-ui/components/use-counter.md): A React Hook for fetching a  value from the Counter API.
- [useDataGrid](https://www.propeldata.com/docs/embeddable-ui/components/use-data-grid.md): A React Hook for fetching tabular data from the Data Grid API.
- [useLeaderboard](https://www.propeldata.com/docs/embeddable-ui/components/use-leaderboard.md): A React Hook for fetching ranked data from the Leaderboard API.
- [useSql](https://www.propeldata.com/docs/embeddable-ui/components/use-sql.md): Query data using SQL.
- [useTimeSeries](https://www.propeldata.com/docs/embeddable-ui/components/use-time-series.md): A React Hook for ready-to-chart time series data from the Time Series API.
- [useTopValues](https://www.propeldata.com/docs/embeddable-ui/components/use-top-values.md): A React Hook for fetching unique values from the Top Values API.
- [Chart.js configuration](https://www.propeldata.com/docs/embeddable-ui/guides/chart-js-configuration.md): Customize Chart.js configuration.
- [Customizing default states](https://www.propeldata.com/docs/embeddable-ui/guides/default-states.md): Customize loading, error and empty states.
- [Logging](https://www.propeldata.com/docs/embeddable-ui/guides/logging.md): Customize error logging.
- [Querying Metrics](https://www.propeldata.com/docs/embeddable-ui/guides/querying-metrics.md): Query metrics from the components.
- [Embeddable UI](https://www.propeldata.com/docs/embeddable-ui/introduction.md): Build custom dashboards insanely fast.
- [Layout](https://www.propeldata.com/docs/embeddable-ui/layout.md): Working with layout components.
- [Starter Apps](https://www.propeldata.com/docs/embeddable-ui/starter-apps.md): Build custom dashboards insanely fast.
- [Breakpoints](https://www.propeldata.com/docs/embeddable-ui/themes/breakpoints.md): Define responsive breakpoints for your layout.
- [Color](https://www.propeldata.com/docs/embeddable-ui/themes/color.md): Understand the color system and its application in your theme.
- [Cursors](https://www.propeldata.com/docs/embeddable-ui/themes/cursors.md): Customize cursor styles for interactive elements.
- [Dark mode](https://www.propeldata.com/docs/embeddable-ui/themes/dark-mode.md): Manage and integrate dark mode.
- [Theme overview](https://www.propeldata.com/docs/embeddable-ui/themes/overview.md): Customize the look and feel of your UI.
- [Radius](https://www.propeldata.com/docs/embeddable-ui/themes/radius.md): Choose the border radius for UI elements.
- [Shadows](https://www.propeldata.com/docs/embeddable-ui/themes/shadows.md): Select shadow styles for your components.
- [Spacing](https://www.propeldata.com/docs/embeddable-ui/themes/spacing.md): Control spacing between components.
- [Typography](https://www.propeldata.com/docs/embeddable-ui/themes/typography.md): Render titles and body copy.
- [Federation to ClickHouse](https://www.propeldata.com/docs/federation/clickhouse/overview.md): Query data from self-hosted or ClickHouse Cloud from Propel.
- [Federation to ClickHouse setup guide](https://www.propeldata.com/docs/federation/clickhouse/setup.md): Connect your ClickHouse to Propel for Federation.
- [Federation](https://www.propeldata.com/docs/federation/overview.md): Query data from other databases and data warehouses.
- [Choosing a Propeller](https://www.propeldata.com/docs/guides/choosing-a-propeller.md): Guide to selecting the optimal Propeller size for your use case
- [Default timestamp](https://www.propeldata.com/docs/guides/default-timestamp.md): How to select and use the optimal default timestamp for your Data Pool
- [Partition key](https://www.propeldata.com/docs/guides/partition-key.md): Example section for showcasing API endpoints
- [Selecting table engine and sorting key](https://www.propeldata.com/docs/guides/table-engine-and-sorting-key.md): How to select the best table engine and sorting key in ClickHouse
- [Airbyte to ClickHouse](https://www.propeldata.com/docs/ingestion/airbyte/overview.md): Ingest data using Airbyte.
- [Airbyte setup guide](https://www.propeldata.com/docs/ingestion/airbyte/setup.md): Ingesting data using Airbyte.
- [Amazon Data Firehose to ClickHouse](https://www.propeldata.com/docs/ingestion/amazon-data-firehose/overview.md): Ingest data from Amazon Data Firehose into Propel.
- [Amazon Data Firehose setup guide](https://www.propeldata.com/docs/ingestion/amazon-data-firehose/setup.md): Ingesting data from Amazon Data Firehose streams to Propel
- [Amazon DynamoDB to ClickHouse](https://www.propeldata.com/docs/ingestion/amazon-dynamodb/overview.md): Ingest data from Amazon DynamoDB into Propel.
- [Amazon DynamoDB setup guide](https://www.propeldata.com/docs/ingestion/amazon-dynamodb/setup.md): Ingesting data from Amazon DynamoDB to Propel
- [Amazon S3 to ClickHouse](https://www.propeldata.com/docs/ingestion/amazon-s3/overview.md): Ingest data from S3.
- [Amazon S3 setup guide](https://www.propeldata.com/docs/ingestion/amazon-s3/setup.md): Ingesting data from Amazon S3 into Propel.
- [Fivetran to ClickHouse](https://www.propeldata.com/docs/ingestion/fivetran/overview.md): Ingest data using Fivetran.
- [Fivetran setup guide](https://www.propeldata.com/docs/ingestion/fivetran/setup.md): Ingesting data using Fivetran.
- [Kafka to ClickHouse](https://www.propeldata.com/docs/ingestion/kafka/overview.md): Ingest data from Kafka topics.
- [Kafka setup guide](https://www.propeldata.com/docs/ingestion/kafka/setup.md): Ingesting Kafka messages into Propel.
- [Ingestion](https://www.propeldata.com/docs/ingestion/overview.md): Easily ingest data into ClickHouse.
- [Change tracking on Snowflake tables](https://www.propeldata.com/docs/ingestion/snowflake/guides/change-tracking.md): How to enable change tracking on Snowflake tables
- [Recovering from a failed sync](https://www.propeldata.com/docs/ingestion/snowflake/guides/failed-syncs.md): What to do when a Snowflake sync fails.
- [Working with Snowflake, dbt, and Propel](https://www.propeldata.com/docs/ingestion/snowflake/guides/snowflake-dbt.md): What you need to know when working with Snowflake,dbt and Propel
- [Snowflake to ClickHouse](https://www.propeldata.com/docs/ingestion/snowflake/overview.md): Ingest data from Snowflake.
- [Snowflake setup guide](https://www.propeldata.com/docs/ingestion/snowflake/setup.md): Ingesting data from Snowflake into Propel.
- [Segment to ClickHouse](https://www.propeldata.com/docs/ingestion/twilio-segment/overview.md): Ingest Segment events to Propel.
- [Twilio Segment setup guide](https://www.propeldata.com/docs/ingestion/twilio-segment/setup.md): Ingesting events from Twilio Segment to Propel
- [Webhooks to ClickHouse](https://www.propeldata.com/docs/ingestion/webhooks/overview.md): Ingest JSON events via HTTP.
- [Webhooks setup guide](https://www.propeldata.com/docs/ingestion/webhooks/setup.md): Ingesting webhook events into Propel
- [Inserting data](https://www.propeldata.com/docs/inserting-data.md): Individual and bulk inserts into ClickHouse
- [Enums](https://www.propeldata.com/docs/management-api/enums.md): Enumeration types in the Management API
- [Inputs](https://www.propeldata.com/docs/management-api/inputs.md): Input types in the Management API
- [Mutations](https://www.propeldata.com/docs/management-api/mutations.md): Available mutations in the Management API
- [Management API reference](https://www.propeldata.com/docs/management-api/overview.md): Manage Propel resources via the API
- [Queries](https://www.propeldata.com/docs/management-api/queries.md): Available queries in the Management API
- [Scalars](https://www.propeldata.com/docs/management-api/scalars.md): Scalar types in the Management API
- [Types](https://www.propeldata.com/docs/management-api/types.md): Object types in the Management API
- [Unions](https://www.propeldata.com/docs/management-api/unions.md): Union types in the Management API
- [Materialized Views](https://www.propeldata.com/docs/materialized-views.md): Transform data with Materialized Views.
- [Multi-tenant JWT tokens](https://www.propeldata.com/docs/multi-tenant-jwt-tokens.md): Using JWT tokens to secure multi-tenant applications.
- [Propel documentation](https://www.propeldata.com/docs/overview.md): Guides, resources, and references to build with Propel.
- [Enums](https://www.propeldata.com/docs/query-apis/api-reference/enums.md): Enumeration types in the Query API
- [Inputs](https://www.propeldata.com/docs/query-apis/api-reference/inputs.md): Input types in the Query API
- [Query API reference](https://www.propeldata.com/docs/query-apis/api-reference/overview.md): GraphQL reference for the Query API.
- [Queries](https://www.propeldata.com/docs/query-apis/api-reference/queries.md): Available queries in the Query API
- [Scalars](https://www.propeldata.com/docs/query-apis/api-reference/scalars.md): Scalar types in the Query API
- [Types](https://www.propeldata.com/docs/query-apis/api-reference/types.md): Object types in the Query API
- [Authentication](https://www.propeldata.com/docs/query-apis/authentication.md): Authenticate your API requests.
- [Counter](https://www.propeldata.com/docs/query-apis/counter.md): Get a single aggregated value for a time range.
- [Data Grid](https://www.propeldata.com/docs/query-apis/data-grid.md): Get a table of records from a Data Pool.
- [Defining Metrics](https://www.propeldata.com/docs/query-apis/defining-metrics.md): Define Metrics using the console, API, or Terraform.
- [Make multiple GraphQL queries in a single request](https://www.propeldata.com/docs/query-apis/guides/how-to-make-multiple-graphQL-queries-in-one-request.md): Optimize your dashboard load times.
- [Pagination](https://www.propeldata.com/docs/query-apis/guides/pagination.md): Cursor-based pagination with GraphQL.
- [Querying JSON data](https://www.propeldata.com/docs/query-apis/guides/querying-json.md): Learn how to query JSON data.
- [Unique names](https://www.propeldata.com/docs/query-apis/guides/unique-names.md): Reference resources by name.
- [Working with timezones](https://www.propeldata.com/docs/query-apis/guides/working-with-timezones.md): Power a localized user experiences.
- [Leaderboard](https://www.propeldata.com/docs/query-apis/leaderboard.md): Get aggregated values grouped by common dimensions.
- [Metric report](https://www.propeldata.com/docs/query-apis/metric-report.md): Get multiple aggregated values grouped by common dimensions.
- [Metrics](https://www.propeldata.com/docs/query-apis/metrics.md): Define and query metrics.
- [Query APIs](https://www.propeldata.com/docs/query-apis/overview.md): Expose any ClickHouse table as an API.
- [SQL API](https://www.propeldata.com/docs/query-apis/sql-api.md): Execute SQL queries from your application.
- [Time Series](https://www.propeldata.com/docs/query-apis/time-series.md): Fetch ready-to-chart time series data.
- [Top values](https://www.propeldata.com/docs/query-apis/top-values.md): Get the most frequent non-null values in a column.
- [Types of Metrics](https://www.propeldata.com/docs/query-apis/types-of-metrics.md): Learn about the different types of metrics.
- [Quickstart](https://www.propeldata.com/docs/quickstart.md): Get up and running with Propel in under 5 minutes.
- [Single Sign-On (SSO)](https://www.propeldata.com/docs/single-sign-on.md): Configure Single Sign-On (SSO) for user authentication.
- [Data types](https://www.propeldata.com/docs/sql-reference/data-types.md): ClickHouse data types in Propel
- [Operators](https://www.propeldata.com/docs/sql-reference/operators.md): ClickHouse operators in Propel
- [Overview](https://www.propeldata.com/docs/sql-reference/overview.md): ClickHouse SQL reference.
- [SELECT](https://www.propeldata.com/docs/sql-reference/statements/select.md): The SELECT statement reference.
- [SHOW TABLES](https://www.propeldata.com/docs/sql-reference/statements/show/tables.md): The SHOW TABLES statement reference.
- [Syntax](https://www.propeldata.com/docs/sql-reference/syntax.md): Learn the key elements of ClickHouse SQL syntax.
- [Table engines](https://www.propeldata.com/docs/sql-reference/table-engines.md): ClickHouse table engines in Propel.
- [Advanced examples](https://www.propeldata.com/docs/terraform/advanced-examples.md): Advanced Terraform examples for Propel resources
- [Propel Terraform provider](https://www.propeldata.com/docs/terraform/overview.md): Manage Propel resources with Terraform
- [Updating data](https://www.propeldata.com/docs/updating-data.md): Real-time and batch updates in ClickHouse.
- [What is ClickHouse®?](https://www.propeldata.com/docs/what-is-clickhouse.md): Learn why ClickHouse is **so fast** for analytical use cases.
- [Why Propel?](https://www.propeldata.com/docs/why-propel.md): Built for developers by ex-Twilio engineers.

## OpenAPI Specs

- [openapi.generated](https://www.propeldata.com/docs/api-reference/openapi.generated.yaml)