Skip to content

feat: Write native destination plugin DDL to files with out executing them on destination #19258

@DougEverly

Description

@DougEverly

Which problem is this feature request solving?

I would like to write the DDL that will be executed to files, without executing them on the destination.

This will allow for:

  • inspection before executing on the destination
  • executing them manually or out-of-band on the desintation as-is
  • allow for modifications before executing (like additional indexes, etc)

An example is given GCP source and Postgresql destination configs, write the SQL to create the tables files without creating/migrating the tables and without syncing.

Describe the solution you'd like

Perhaps adding "ddl" or "native" format to the --format flag.

cloudquery tables ./directory --filter spec --format native

The output is whatever code is generated to create the destination object (table, etc).

  • postgresql would emit SQL
  • etc

Pull request (optional)

  • I can submit a pull request

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions