SQL Schema Limits

Section header image mobile
 

A growing number of schemas often reflects business success, but it can also lead to slower import previews. With Coefficient's Schema Limit feature, you can streamline your workflow by selecting the schemas you need, hiding those you don’t, and optimizing the interface for a faster, more efficient import process.

Designate Schema(s) for your Connection(s)

Create an Import Using SQL Schema Limits

FAQs for Schema Limit 

Designate Schema(s) for your Connection(s)

 ℹ️ NOTE: The Coefficient Schema Limit feature is available for integrations using SQL connectors, including Postgres, MySQL, MS SQL, Snowflake, Redshift, BigQuery, and Databricks.

1. Open the Coefficient Sidebar and click on the Menu.

MenuIconUpdated.png

2. Select “Connected Sources”.

ConnectedSources.png

3. Choose the data source to apply the schema limit. (Example: MySQL Connection 1)

4. Click Edit. 

5. Select Advanced Settings. 

6. Under the Advanced Settings, you will see Visible Schemas. 

 

 

7. Click inside the "Visible Schemas" box to view a list of schemas available for this data source connection. Select the schemas you want to include, then click Save. The selected schemas will appear in the import preview window for future imports.

8. After clicking "Save," you will be able to see the selected schemas under "Visible Schemas." You can now begin creating your import. 

 

mceclip1.png

Create an Import Using SQL Schema Limits 

1. Once you've saved the selected schemas, you can create your import by simply clicking "Import Data." 

ℹ️ NOTE: If you'd like to create another import using the same selected schemas, go to the main menu and choose "Import from." This will retain the schemas you’ve already selected.

2. Choose your preferred method for creating the import. For this example, we’ll be using "Table & Columns."

3. Once the Import Preview page launches, only the schemas you selected will appear in the preview's left sidebar. 

Example: file_rentals_actor

4. In the next step, you will see all the fields within the schema selected in Step #3. 

5. Select/Unselect the fields you need for your import on the left side of the Import Preview window. The data preview section updates as you change your settings (the first 50 rows of data are shown). You can drag and drop column headers to change their order in your import. Customize your import by adding filters and row limits as needed. When done, click “Import”.

FAQ for Schema Limits 

Do I need to configure the schema limit separately for each import method (Example: Table and Columns)? 

No, the schemas saved in Visible Schemas apply to all import methods, so you only need to set the schema limit once. Any changes will automatically update across the interface.

What if I want to include a schema in a Custom SQL Query?

If you know the schema name, you can manually enter it in the Custom SQL query section to run your query. Additionally, when using a custom SQL query to create an import, you can query any database objects (tables, views, etc.) permitted by the connection’s SQL permissions—even if the schemas are hidden using Coefficient’s schema hiding feature.

Can I view all available schemas?

Yes, by default, all schemas are displayed when creating an import. However, if your database has a large number of schemas, you can improve load times by limiting the display to a subset of schemas.

Does hiding a schema block users from querying its tables or views?

No, the schema limit feature is designed for convenience, not security. It helps declutter the Coefficient UI by hiding unnecessary schemas but does not prevent users from querying hidden tables or views. To enforce access restrictions, use your SQL database's native user access controls.

Why can’t I see a schema in BigQuery?

In BigQuery, "Dataset" is used instead of "Schema," but the functionality remains unchanged. This feature is compatible with BigQuery Service Accounts.

What happens to existing imports that now exclude reference schemas from the schema limit?

If a user edits an existing import and the schema is no longer accessible due to the new limitations, the import may fail. However, users can still work on the import but will be restricted to making updates within the boundaries of the updated schema settings.

Can I manually type a schema in the Import Preview (from Table and Columns mode)?

No, manually typing a schema is only supported in Custom SQL Query and GPT SQL modes. Coefficient fetches the schemas dynamically from your database.

 

Was this article helpful? 0 out of 0 found this helpful