aws_access_key_id
: The AWS access key that identifies the user or IAM role.aws_secret_access_key
: The AWS secret access key that identifies the user or IAM role.region_name
: The AWS region to connect to.aws_session_token
: The AWS session token that identifies the user or IAM role. This becomes necessary when using temporary security credentials.LIMIT
, GROUP BY
and HAVING
clauses are not supported in PartiQL SELECT
statements. Furthermore, subqueries and joins are not supported either. Refer to the PartiQL documentation for SELECT statements for more information.INSERT
statements are not supported by this integration. However, this can be overcome by issuing a ‘native query’ via an established connection. An example of this is provided below.dynamodb_datasource
as the datasource name, which is defined in the CREATE DATABASE
command.Database Connection Error
SQL statement cannot be parsed by mindsdb_sql