sdm admin datasources add

Last modified on March 24, 2023

NAME:
   sdm admin datasources add - add one or more datasources

USAGE:
   sdm admin datasources add command [command options] [arguments...]

COMMANDS:
   amazones             create Amazon ES datasource
   athena               create Athena datasource
   aurora-mysql         create Aurora MySQL datasource
   aurora-postgres      create Aurora PostgreSQL datasource
   bigquery             create BigQuery datasource
   cassandra            create Cassandra datasource
   citus                create Citus datasource
   clustrix             create Clustrix datasource
   cockroach            create CockroachDB datasource
   druid                create Druid datasource
   dynamo               create DynamoDB datasource
   ecredis              create ElastiCache Redis datasource
   elastic              create Elasticsearch datasource
   greenplum            create Greenplum datasource
   maria                create Maria datasource
   memcached            create Memcached datasource
   memsql               create MemSQL datasource
   mongo                create MongoDB datasource
   mongo-replicaset     create MongoDB (replica set) datasource
   mssql                create Microsoft SQL Server datasource
   mysql                create MySQL datasource
   postgres             create PostgreSQL datasource
   presto               create Presto datasource
   redis                create Redis datasource
   redshift             create Redshift datasource
   snowflake            create Snowflake datasource
   sybase               create Sybase ASE datasource
   sybase-iq, sybaseiq  create Sybase IQ datasource

OPTIONS:
   --file value, -f value  load from a JSON file
   --stdin, -i             load from stdin
   --help, -h              show help

amazones

NAME:
   sdm admin datasources add amazones - create Amazon ES datasource

USAGE:
   sdm admin datasources add amazones [command options] <name>

OPTIONS:
   --access-key-id value      (secret)
   --egress-filter value      apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --endpoint value           
   --port-override value      port profile override (default: -1)
   --region value             (required)
   --role-arn value           Enter the role to assume after logging in. (Optional) (secret)
   --role-external-id value   (secret)
   --secret-access-key value  (secret)
   --secret-store-id value    secret store id
   --tags value               tags e.g. 'key=value,...'
   --template, -t             display a JSON template

athena

NAME:
   sdm admin datasources add athena - create Athena datasource

USAGE:
   sdm admin datasources add athena [command options] <name>

OPTIONS:
   --aws-access-key-id value      (required, secret)
   --aws-secret-access-key value  (required, secret)
   --egress-filter value          apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --port-override value          port profile override (default: -1)
   --region value                 
   --role-arn value               Enter the role to assume after logging in. (Optional) (secret)
   --role-external-id value       (secret)
   --s3-output-location value     (required)
   --secret-store-id value        secret store id
   --tags value                   tags e.g. 'key=value,...'
   --template, -t                 display a JSON template

aurora-mysql

NAME:
   sdm admin datasources add aurora-mysql - create Aurora MySQL datasource

USAGE:
   sdm admin datasources add aurora-mysql [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 3306)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

aurora-postgres

NAME:
   sdm admin datasources add aurora-postgres - create Aurora PostgreSQL datasource

USAGE:
   sdm admin datasources add aurora-postgres [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5432)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

bigquery

NAME:
   sdm admin datasources add bigquery - create BigQuery datasource

USAGE:
   sdm admin datasources add bigquery [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --endpoint value         (required)
   --port-override value    port profile override (default: -1)
   --private-key value      (required, secret)
   --project value          (required)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value

cassandra

NAME:
   sdm admin datasources add cassandra - create Cassandra datasource

USAGE:
   sdm admin datasources add cassandra [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 9042)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --tls-required           sdm must use TLS to connect
   --username value         (required, secret)

citus

NAME:
   sdm admin datasources add citus - create Citus datasource

USAGE:
   sdm admin datasources add citus [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5432)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

clustrix

NAME:
   sdm admin datasources add clustrix - create Clustrix datasource

USAGE:
   sdm admin datasources add clustrix [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 3306)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

cockroach

NAME:
   sdm admin datasources add cockroach - create CockroachDB datasource

USAGE:
   sdm admin datasources add cockroach [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5432)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

druid

NAME:
   sdm admin datasources add druid - create Druid datasource

USAGE:
   sdm admin datasources add druid [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 8082)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (secret)

dynamo

NAME:
   sdm admin datasources add dynamo - create DynamoDB datasource

USAGE:
   sdm admin datasources add dynamo [command options] <name>

OPTIONS:
   --access-key-id value      (required, secret)
   --egress-filter value      apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --endpoint value           (required)
   --port-override value      port profile override (default: -1)
   --region value             (required)
   --role-arn value           Enter the role to assume after logging in. (Optional) (secret)
   --role-external-id value   (secret)
   --secret-access-key value  (required, secret)
   --secret-store-id value    secret store id
   --tags value               tags e.g. 'key=value,...'
   --template, -t             display a JSON template

ecredis

NAME:
   sdm admin datasources add ecredis - create ElastiCache Redis datasource

USAGE:
   sdm admin datasources add ecredis [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 6379)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --tls-required           sdm must use TLS to connect

elastic

NAME:
   sdm admin datasources add elastic - create Elasticsearch datasource

USAGE:
   sdm admin datasources add elastic [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 9200)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --tls-required           sdm must use TLS to connect
   --username value         (required, secret)

greenplum

NAME:
   sdm admin datasources add greenplum - create Greenplum datasource

USAGE:
   sdm admin datasources add greenplum [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5432)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

maria

NAME:
   sdm admin datasources add maria - create Maria datasource

USAGE:
   sdm admin datasources add maria [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 3306)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

memcached

NAME:
   sdm admin datasources add memcached - create Memcached datasource

USAGE:
   sdm admin datasources add memcached [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --port value             (default: 11211)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template

memsql

NAME:
   sdm admin datasources add memsql - create MemSQL datasource

USAGE:
   sdm admin datasources add memsql [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 3306)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

mongo

NAME:
   sdm admin datasources add mongo - create MongoDB datasource

USAGE:
   sdm admin datasources add mongo [command options] <name>

OPTIONS:
   --auth-database value       (required)
   --connect-to-replica value  Connect to a replica instead of the primary node.
   --egress-filter value       apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value            (required)
   --password value            (secret)
   --port value                (default: 27017)
   --port-override value       port profile override (default: -1)
   --replica-set value         The name of the mongo replicaset
   --secret-store-id value     secret store id
   --tags value                tags e.g. 'key=value,...'
   --template, -t              display a JSON template
   --tls-required              sdm must use TLS to connect
   --username value            (secret)

mongo-replicaset

NAME:
   sdm admin datasources add mongo-replicaset - create MongoDB (replica set) datasource

USAGE:
   sdm admin datasources add mongo-replicaset [command options] <name>

OPTIONS:
   --auth-database value       (required)
   --connect-to-replica value  Connect to a replica instead of the primary node.
   --egress-filter value       apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value            (required)
   --password value            (secret)
   --port value                (default: 27017)
   --port-override value       port profile override (default: -1)
   --replica-set value         The name of the mongo replicaset
   --secret-store-id value     secret store id
   --tags value                tags e.g. 'key=value,...'
   --template, -t              display a JSON template
   --tls-required              sdm must use TLS to connect
   --username value            (secret)

mssql

NAME:
   sdm admin datasources add mssql - create Microsoft SQL Server datasource

USAGE:
   sdm admin datasources add mssql [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Clients connect to the configured database by default.
   --password value         (required, secret)
   --port value             (default: 1433)
   --port-override value    port profile override (default: -1)
   --schema value           
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

mysql

NAME:
   sdm admin datasources add mysql - create MySQL datasource

USAGE:
   sdm admin datasources add mysql [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port value             (default: 3306)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

postgres

NAME:
   sdm admin datasources add postgres - create PostgreSQL datasource

USAGE:
   sdm admin datasources add postgres [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5432)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

presto

NAME:
   sdm admin datasources add presto - create Presto datasource

USAGE:
   sdm admin datasources add presto [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 8080)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --tls-required           sdm must use TLS to connect
   --username value

redis

NAME:
   sdm admin datasources add redis - create Redis datasource

USAGE:
   sdm admin datasources add redis [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 6379)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template

redshift

NAME:
   sdm admin datasources add redshift - create Redshift datasource

USAGE:
   sdm admin datasources add redshift [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --override-database      Limit all connections to the configured database
   --password value         (required, secret)
   --port value             (default: 5439)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

snowflake

NAME:
   sdm admin datasources add snowflake - create Snowflake datasource

USAGE:
   sdm admin datasources add snowflake [command options] <name>

OPTIONS:
   --database value         (required)
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (required, secret)
   --port-override value    port profile override (default: -1)
   --schema value           (required)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

sybase

NAME:
   sdm admin datasources add sybase - create Sybase ASE datasource

USAGE:
   sdm admin datasources add sybase [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 2638)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)

sybase-iq

NAME:
   sdm admin datasources add sybase-iq - create Sybase IQ datasource

USAGE:
   sdm admin datasources add sybase-iq [command options] <name>

OPTIONS:
   --egress-filter value    apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
   --hostname value         (required)
   --password value         (secret)
   --port value             (default: 2638)
   --port-override value    port profile override (default: -1)
   --secret-store-id value  secret store id
   --tags value             tags e.g. 'key=value,...'
   --template, -t           display a JSON template
   --username value         (required, secret)