New in CData Connect Cloud: Schedule Queries to Automate Data Connections

We’re adding a new capability in CData Connect Cloud: scheduled queries. Starting at the end of January, all users will be able to schedule queries to automatically write data to supported destinations based on a schedule they set. This feature enhances the platform’s capability, empowering technical users to build dynamic, low-maintenance data workflows without heavy infrastructure investment.

With scheduled queries, users can harness the power of our Query Builder or write custom SQL queries themselves directly in the Data Explorer. These queries can then be scheduled to run at regular intervals, ensuring your data is up to date when needed in the destination of your choice.

Supported destinations

CData Connect Cloud supports the following destinations for scheduled queries:

• BigQuery
• Databricks
• PostgreSQL
• Redshift
• Smartsheet
• Snowflake

Key benefits of scheduled queries

• Automation without complexity
  No need to set up elaborate data pipelines or write custom scripts. Simply create your query, define your schedule, and let CData Connect Cloud handle the rest.

• Dynamic data delivery
  Keep your data fresh and relevant by ensuring it's delivered to your destination exactly when it’s needed.

• Broad connectivity
  Write data from hundreds of sources to the platforms where you analyze, visualize, and act on it. From project planning in Smartsheet to analytics in Snowflake, Scheduled Queries makes it seamless.

• Accelerate use cases
  Build workflows to automate reporting, consolidate data from disparate systems, or keep project management tools updated with the latest insights.

How scheduled queries work

1. Create your query: Use the intuitive Query Builder or write a SQL query manually in the Data Explorer.
2. Set the schedule: Define when and how often the query runs. Whether it’s daily updates at 9 PM or every Monday at noon, you’re in control.
3. Select your destination: Choose your target from our supported destinations.
4. Relax: Watch as your data actually writes to your destination on schedule.

Start building smarter data workflows

Scheduled queries are an effective and easy way for anyone looking to automate their data delivery. Ready to get started? Try scheduling queries yourself in the Connect Cloud Data Explorer today with a free 30-day trial.