SUPPORT.TWILIO.COM END OF LIFE NOTICE: This site, support.twilio.com, is scheduled to go End of Life on February 27, 2024. All Twilio Support content has been migrated to help.twilio.com, where you can continue to find helpful Support articles, API docs, and Twilio blog content, and escalate your issues to our Support team. We encourage you to update your bookmarks and begin using the new site today for all your Twilio Support needs.

How to change a schema name once it had already been created

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 

  1. Open the Segment app, select Connections and click Destinations.
  2. Select the warehouse you’d like to rename the schema for from the list of destinations.
  3. On the overview page for your source, select Settings.
  4. Disable the Sync Data toggle and click Save Settings.
  5. Select Connections and click Sources.
  6. Select a source that syncs data with your warehouse from your list of sources, and select Settings.
  7. 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.

  8. Open the third-party host of your database, and rename the schema there.
  9. Open the Segment app, select Connections and click Destinations.
  10. Select the warehouse you disabled syncs for from the list of destinations.
  11. On the overview page for your source, select Settings.
  12. Enable the Sync Data toggle and click Save Settings.

 

Additional Information 

Further details on changing things in your warehouse can be found here.

Have more questions? Submit a request
Powered by Zendesk