Manage Data Sources
Last updated
Last updated
If you need to make changes to your data sources, you can do that from the Settings page. There are a couple of things you can do to data sources.
In terms of pricing, Select Star counts data sources by type. So having multiple connections to 1 single data source type, will only count as 1 data source for pricing.
Go to Settings, then click Data under the Admin section in the sidebar.
Click the button next to Data Sources that says + Add.
This will open a pop-up that will have a dropdown of the available integrations. Choose your integration and fill out the required information. You can find detailed information on how to set up each integration by clicking on the link below 👇
Metadata is automatically synced every 24 hours at 8am UTC, but you can manually trigger a metadata sync at any time.
Go to Settings > Data.
Click Sync metadata for the desired data source. Depending on how much metadata you've generated, it might take a little while. You can see when the metadata sync is done when it goes from Sync in progress back to Sync metadata.
By default we automatically sync new data assets that are detected in your data source. So new Databases, Schemas, Tables or Views, will automatically show up in Select Star after they are created in the source and we have synced the metadata.
There are some exceptions to this, where you will need to grant the permissions explicitly for Select Star to detect this. Check PostgreSQL syncing new schemas.
If you don't want to automatically sync your newly created data assets, we can also disable that feature for you. Reach out to us.
Admins can change which database and schema metadata is available in your organization’s Select Star instance.
Go to Settings and click Data in the sidebar.
Databases, such as Snowflake and BigQuery will show a button that says Configure.
BI Tools cannot be configured, but don't worry - any new reports or dashboards you create in a BI Tool will be automatically loaded in a metadata sync.
Click on Configure to bring up a popup similar to the one seen when adding a Data Source. The Service Account login information is saved, so you can go right to changing which databases and schemas you’d like to add to or remove from the instance.
If your database has a few test tables, or if you have personal reports you don’t want to see in Select Star, you can hide them from view without deleting entire data sources.
From the database or dashboard page, select the datasets you’d like to remove and click the Hide button.
⌨️ You can hold the Shift key to select consecutive tables.
When you click Hide, you will be prompted to confirm you want to remove the tables.
Your automatic metadata sync will not add the tables back into Select Star. If you want to see the tables again, you will have to unhide them.
To unhide hidden datasets, go to the database page. In the right sidebar, check the Hidden filter to see all your hidden tables.
Check any datasets you want to show in Select Star, then click Unhide.
You will be asked to confirm you want to show the hidden datasets in Select Star. After you confirm, datasets will be visible to everyone in your organization.
If you need to delete a data source, go to Settings and click Data.
Click the Delete button next to the data source.
You will be prompted to confirm if you want to delete the source.
Everything in Select Star - including metadata, descriptions, tags, users - will be removed and can not be recovered if you delete the data source.
