Duplicate Connectors and mass Edit connectors


related to https://dojo.domo.com/main/discussion/comment/57517#Comment_57517
Especially when we need to create n connectors from the same database and schema, it would be ideal to be able to duplicate the connector and then just change the sql query.
when building connectors against databases that have many tables, it can take a while for the connector to finish discovering all the possible values. or worse, when the connecter UI forces you to select a value from a dropdown instead of typing the value in, if your table is at the later end of the alphabet, this can be particularly frustrating
An additional frustration is if you're trying to switch between a version of a connector to a different implementation (ex. Postgresql vs Postgresql_unloadv2 + partitioning).
It would be ideal if connectors could be gathered under some sort of umbrella and key configuration criteria could be updated en-masse. ex execution time, a LIMIT clause, the account used to authenticate, the connector type etc.
For one of my projects my team had to set up 30 Snowflake connectors.
Then modify QUERY with a LIMIT 1000 clause.
Then modify with a LIMIT 50000 clause.
Then change to using Partitions.
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive