Objective
The steps below should help you change a schema name that has already been created in your warehouse.
Product
Twilio Segment
Environment
Segment Console
Procedure
- Open the Segment app, select Connections and click Destinations.
- Select the warehouse you’d like to rename the schema for from the list of destinations.
- On the overview page for your source, select Settings.
- Disable the Sync Data toggle and click Save Settings.
- Select Connections and click Sources.
- Select a source that syncs data with your warehouse from your list of sources, and select Settings.
-
Select SQL Settings and update the Schema Name field with the new name for your schema and click Save Changes.
Note: This sets the schema name for all existing and future destinations. The new name must be lowercase and may include underscores.
- Open the third-party host of your database, and rename the schema there.
- Open the Segment app, select Connections and click Destinations.
- Select the warehouse you disabled syncs for from the list of destinations.
- On the overview page for your source, select Settings.
- Enable the Sync Data toggle and click Save Settings.
Additional Information
Further details on changing things in your warehouse can be found here.