sdm admin resources add
Last modified on September 11, 2023
NAME:
sdm admin resources add - add one or more resources
USAGE:
sdm admin resources add command [command options] [arguments...]
COMMANDS:
amazones create Amazon ES datasource
amazonmq-amqp-091 create Amazon MQ (AMQP 0.9.1) datasource
athena create Athena datasource
aurora-mysql create Aurora MySQL datasource
aurora-postgres create Aurora PostgreSQL datasource
azuremysql create Azure Database for MySQL datasource
azurepostgres create Azure Database for PostgreSQL datasource
bigquery create BigQuery datasource
cassandra create Cassandra datasource
citus create Citus datasource
clustrix create Clustrix datasource
cockroach create CockroachDB datasource
db2i create Db2i datasource
db2luw create Db2 LUW datasource
documentdbhost create DocumentDB (single host) datasource
documentdbreplicaset create DocumentDB (replica set) datasource
druid create Druid datasource
dynamo create DynamoDB datasource
ecredis create ElastiCache Redis datasource
elastic create Elasticsearch datasource
greenplum create Greenplum datasource
mTLSPostgres create PostgreSQL (mTLS) datasource
maria create Maria datasource
memcached create Memcached datasource
memsql create MemSQL datasource
mongo create MongoDB (single host) datasource
mongo-replicaset create MongoDB (replica set) datasource
mssql create Microsoft SQL Server datasource
mssqlAzureAD create Microsoft SQL Server (Azure AD) datasource
mssqlKerberos create Microsoft SQL Server (Kerberos) datasource
mysql create MySQL datasource
neptune create Neptune datasource
neptuneiam create Neptune (IAM) datasource
oracle create Oracle datasource
postgres create PostgreSQL datasource
presto create Presto datasource
rabbitmq-amqp-091 create RabbitMQ (AMQP 0.9.1) datasource
redis create Redis datasource
redshift create Redshift datasource
singlestore create SingleStore datasource
snowflake create Snowflake datasource
sybase create Sybase ASE datasource
sybase-iq, sybaseiq create Sybase IQ datasource
teradata create Teradata datasource
OPTIONS:
--file value, -f value load from a JSON file
--stdin, -i load from stdin
--timeout value set time limit for command
--help, -h show help
amazones
NAME:
sdm admin resources add amazones - create Amazon ES datasource
USAGE:
sdm admin resources add amazones [command options] <name>
OPTIONS:
--access-key-id value (secret)
--bind-interface value bind interface (default: "127.0.0.1")
--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 The role to assume after logging in. (secret)
--role-external-id value (secret)
--secret-access-key value (secret)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
amazonmq-amqp-091
NAME:
sdm admin resources add amazonmq-amqp-091 - create Amazon MQ (AMQP 0.9.1) datasource
USAGE:
sdm admin resources add amazonmq-amqp-091 [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--hostname value Do not include the protocol or port. (required)
--password value (required, secret)
--port value (default: 5671)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required Use TLS to connect to the AMQP server
--username value (required, secret)
athena
NAME:
sdm admin resources add athena - create Athena datasource
USAGE:
sdm admin resources add athena [command options] <name>
OPTIONS:
--aws-access-key-id value (required, secret)
--aws-secret-access-key value (required, secret)
--bind-interface value bind interface (default: "127.0.0.1")
--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 The role to assume after logging in. (secret)
--role-external-id value (secret)
--s3-output-location value (required)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
aurora-mysql
NAME:
sdm admin resources add aurora-mysql - create Aurora MySQL datasource
USAGE:
sdm admin resources add aurora-mysql [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
aurora-postgres
NAME:
sdm admin resources add aurora-postgres - create Aurora PostgreSQL datasource
USAGE:
sdm admin resources add aurora-postgres [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
azuremysql
NAME:
sdm admin resources add azuremysql - create Azure Database for MySQL datasource
USAGE:
sdm admin resources add azuremysql [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
azurepostgres
NAME:
sdm admin resources add azurepostgres - create Azure Database for PostgreSQL datasource
USAGE:
sdm admin resources add azurepostgres [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value The Username will be augmented with the hostname for compatibility with Azure Single Server types. For Flexible servers, use the normal Postgres type. (required, secret)
bigquery
NAME:
sdm admin resources add bigquery - create BigQuery datasource
USAGE:
sdm admin resources add bigquery [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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 The file path of the private key used to authenticate with the server. (required, secret)
--project value (required)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value
cassandra
NAME:
sdm admin resources add cassandra - create Cassandra datasource
USAGE:
sdm admin resources add cassandra [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required Use TLS to connect to the Cassandra sever
--username value (required, secret)
citus
NAME:
sdm admin resources add citus - create Citus datasource
USAGE:
sdm admin resources add citus [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
clustrix
NAME:
sdm admin resources add clustrix - create Clustrix datasource
USAGE:
sdm admin resources add clustrix [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
cockroach
NAME:
sdm admin resources add cockroach - create CockroachDB datasource
USAGE:
sdm admin resources add cockroach [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
db2i
NAME:
sdm admin resources add db2i - create Db2i datasource
USAGE:
sdm admin resources add db2i [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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 (required) (default: 8471)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
db2luw
NAME:
sdm admin resources add db2luw - create Db2 LUW datasource
USAGE:
sdm admin resources add db2luw [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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: 50000)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
documentdbhost
NAME:
sdm admin resources add documentdbhost - create DocumentDB (single host) datasource
USAGE:
sdm admin resources add documentdbhost [command options] <name>
OPTIONS:
--auth-database value (required)
--bind-interface value bind interface (default: "127.0.0.1")
--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)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (secret)
documentdbreplicaset
NAME:
sdm admin resources add documentdbreplicaset - create DocumentDB (replica set) datasource
USAGE:
sdm admin resources add documentdbreplicaset [command options] <name>
OPTIONS:
--auth-database value (required)
--bind-interface value bind interface (default: "127.0.0.1")
--connect-to-replica 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 Hostnames and ports of all instances in the replica set separated by commas (required)
--password value (secret)
--port-override value port profile override (default: -1)
--replica-set value The name of the mongo replicaset (required)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (secret)
druid
NAME:
sdm admin resources add druid - create Druid datasource
USAGE:
sdm admin resources add druid [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (secret)
dynamo
NAME:
sdm admin resources add dynamo - create DynamoDB datasource
USAGE:
sdm admin resources add dynamo [command options] <name>
OPTIONS:
--access-key-id value (required, secret)
--bind-interface value bind interface (default: "127.0.0.1")
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--endpoint value Do not include the protocol or port. (required)
--port-override value port profile override (default: -1)
--region value (required)
--role-arn value The role to assume after logging in. (secret)
--role-external-id value (secret)
--secret-access-key value (required, secret)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
ecredis
NAME:
sdm admin resources add ecredis - create ElastiCache Redis datasource
USAGE:
sdm admin resources add ecredis [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (secret)
elastic
NAME:
sdm admin resources add elastic - create Elasticsearch datasource
USAGE:
sdm admin resources add elastic [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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: 9200)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (secret)
greenplum
NAME:
sdm admin resources add greenplum - create Greenplum datasource
USAGE:
sdm admin resources add greenplum [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
mTLSPostgres
NAME:
sdm admin resources add mTLSPostgres - create PostgreSQL (mTLS) datasource
USAGE:
sdm admin resources add mTLSPostgres [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--certificate-authority value Server CA for TLS verification (unverified by StrongDM if empty) (secret)
--client-certificate value (required, secret)
--client-key value (required, secret)
--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
--server-name value Server name for TLS verification (unverified by StrongDM if empty)
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
maria
NAME:
sdm admin resources add maria - create Maria datasource
USAGE:
sdm admin resources add maria [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
memcached
NAME:
sdm admin resources add memcached - create Memcached datasource
USAGE:
sdm admin resources add memcached [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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)
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
memsql
NAME:
sdm admin resources add memsql - create MemSQL datasource
USAGE:
sdm admin resources add memsql [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
mongo
NAME:
sdm admin resources add mongo - create MongoDB (single host) datasource
USAGE:
sdm admin resources add mongo [command options] <name>
OPTIONS:
--auth-database value (required)
--bind-interface value bind interface (default: "127.0.0.1")
--connect-to-replica 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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (secret)
mongo-replicaset
NAME:
sdm admin resources add mongo-replicaset - create MongoDB (replica set) datasource
USAGE:
sdm admin resources add mongo-replicaset [command options] <name>
OPTIONS:
--auth-database value (required)
--bind-interface value bind interface (default: "127.0.0.1")
--connect-to-replica 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 (required)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (secret)
mssql
NAME:
sdm admin resources add mssql - create Microsoft SQL Server datasource
USAGE:
sdm admin resources add mssql [command options] <name>
OPTIONS:
--allow-deprecated-encryption value Whether to allow deprecated encryption protocols to be used for this resource. For example, TLS 1.0
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is used for healthchecks and overrides client databases if Override Default Database is configured.
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
mssqlAzureAD
NAME:
sdm admin resources add mssqlAzureAD - create Microsoft SQL Server (Azure AD) datasource
USAGE:
sdm admin resources add mssqlAzureAD [command options] <name>
OPTIONS:
--allow-deprecated-encryption value Whether to allow deprecated encryption protocols to be used for this resource. For example, TLS 1.0
--bind-interface value bind interface (default: "127.0.0.1")
--client-id value The Azure AD application (client) ID with which to authenticate. (required, secret)
--database value This database is used for healthchecks and overrides client databases if Override Default Database is configured.
--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.
--port value (default: 1433)
--port-override value port profile override (default: -1)
--schema value
--secret value The Azure AD client secret (application password) with which to authenticate. (required, secret)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--tenant-id value The Azure AD directory (tenant) ID with which to authenticate. (required, secret)
--timeout value set time limit for command
mssqlKerberos
NAME:
sdm admin resources add mssqlKerberos - create Microsoft SQL Server (Kerberos) datasource
USAGE:
sdm admin resources add mssqlKerberos [command options] <name>
OPTIONS:
--allow-deprecated-encryption value Whether to allow deprecated encryption protocols to be used for this resource. For example, TLS 1.0
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is used for healthchecks and overrides client databases if Override Default Database is configured.
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--hostname value (required)
--keytab value The keytab file in base64 format containing an entry with the principal name (<username>@<realm>) and key version number with which to authenticate. (required, secret)
--krb-config value The Kerberos 5 configuration file (krb5.conf) specifying the Active Directory server (KDC) for the configured realm. (required, secret)
--override-database Clients connect to the configured database by default.
--port value (default: 1433)
--port-override value port profile override (default: -1)
--realm value The Active Directory domain (realm) to which the configured username belongs. (required, secret)
--schema value
--secret-store-id value secret store id
--server-spn value The Service Principal Name of the Microsoft SQL Server instance in Active Directory. (required, secret)
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value The Active Directory username with which to authenticate. (required, secret)
mysql
NAME:
sdm admin resources add mysql - create MySQL datasource
USAGE:
sdm admin resources add mysql [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
neptune
NAME:
sdm admin resources add neptune - create Neptune datasource
USAGE:
sdm admin resources add neptune [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--endpoint value (required)
--port value (default: 8182)
--port-override value port profile override (default: -1)
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
neptuneiam
NAME:
sdm admin resources add neptuneiam - create Neptune (IAM) datasource
USAGE:
sdm admin resources add neptuneiam [command options] <name>
OPTIONS:
--access-key-id value (required, secret)
--bind-interface value bind interface (default: "127.0.0.1")
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--endpoint value (required)
--port value (default: 8182)
--port-override value port profile override (default: -1)
--region value (required)
--role-arn value The role to assume after logging in. (secret)
--role-external-id value (secret)
--secret-access-key value (required, secret)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
oracle
NAME:
sdm admin resources add oracle - create Oracle datasource
USAGE:
sdm admin resources add oracle [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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 (required) (default: 1521)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (required, secret)
postgres
NAME:
sdm admin resources add postgres - create PostgreSQL datasource
USAGE:
sdm admin resources add postgres [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
presto
NAME:
sdm admin resources add presto - create Presto datasource
USAGE:
sdm admin resources add presto [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
rabbitmq-amqp-091
NAME:
sdm admin resources add rabbitmq-amqp-091 - create RabbitMQ (AMQP 0.9.1) datasource
USAGE:
sdm admin resources add rabbitmq-amqp-091 [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--hostname value Do not include the protocol or port. (required)
--password value (required, secret)
--port value (default: 5672)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required Use TLS to connect to the AMQP server
--username value (required, secret)
redis
NAME:
sdm admin resources add redis - create Redis datasource
USAGE:
sdm admin resources add redis [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--tls-required sdm must use TLS to connect
--username value (secret)
redshift
NAME:
sdm admin resources add redshift - create Redshift datasource
USAGE:
sdm admin resources add redshift [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
singlestore
NAME:
sdm admin resources add singlestore - create SingleStore datasource
USAGE:
sdm admin resources add singlestore [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value This database is exclusively used for healthchecks; the database sent by clients is respected otherwise.
--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)
--require-native-auth Whether native auth (mysql_native_password) is used for all connections (for backwards compatibility)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--use-azure-single-server-usernames If true, appends the hostname to the username when hitting a database.azure.com address
--username value (required, secret)
snowflake
NAME:
sdm admin resources add snowflake - create Snowflake datasource
USAGE:
sdm admin resources add snowflake [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--database value (required)
--egress-filter value apply filter to select egress nodes e.g. 'field:name tag:key=value ...'
--hostname value Do not include the protocol or port. (required)
--password value (required, secret)
--port-override value port profile override (default: -1)
--schema value
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
sybase
NAME:
sdm admin resources add sybase - create Sybase ASE datasource
USAGE:
sdm admin resources add sybase [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
sybase-iq, sybaseiq
NAME:
sdm admin resources add sybase-iq - create Sybase IQ datasource
USAGE:
sdm admin resources add sybase-iq [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)
teradata
NAME:
sdm admin resources add teradata - create Teradata datasource
USAGE:
sdm admin resources add teradata [command options] <name>
OPTIONS:
--bind-interface value bind interface (default: "127.0.0.1")
--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: 1025)
--port-override value port profile override (default: -1)
--secret-store-id value secret store id
--subdomain value This will be used as your local DNS address. (e.g. app-prod1 would turn into app-prod1.<your-org-name>.sdm.network)
--tags value tags e.g. 'key=value,...'
--template, -t display a JSON template
--timeout value set time limit for command
--username value (required, secret)