本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。
呼叫資料 API
您可以調用數據API或 AWS CLI 以在叢集或無伺服器工作群組上執行SQL陳述式。執行SQL陳述式的主要作業是 Amazon Redshift 資料API參考BatchExecuteStatement
中的ExecuteStatement
和。資料API支援所支援的程式設計語言 AWS SDK。如需這些資訊的詳細資訊,請參閱建置在其上的工具 AWS
若要查看呼叫資料的程式碼範例API,請參閱API中GitHub的 Redshift 資料入門
您可以API使用 AWS CLI.
下面的實例使用 AWS CLI 調用數據API。若要執行範例,請編輯參數值以符合您的環境。許多範例會提供 cluster-identifier
來針對叢集執行。當您針對無伺服器工作群組執行時,請改為提供 workgroup-name
。這些實例演示了一些數據API操作。如需詳細資訊,請參閱 AWS CLI 指令參考。
下列範例中的命令已經過分割和格式化,以方便您閱讀。
若要執行SQL陳述式
若要執行SQL陳述式,請使用 aws redshift-data execute-statement
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,並傳回識別碼以擷取結果。此範例使用 AWS Secrets Manager 驗證方法。
aws redshift-data execute-statement --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --sql "select * from stl_query limit 1" --database dev
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598323175.823, "Database": "dev", "Id": "c016234e-5c6c-4bc5-bb16-2c5b8ff61814", "SecretArn": "arn:aws:secretsmanager:us-west-2:123456789012:secret:yanruiz-secret-hKgPWn" }
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,並傳回識別碼以擷取結果。此範例使用暫時憑證身分驗證方法。
aws redshift-data execute-statement --region us-west-2 --db-user myuser --cluster-identifier mycluster-test --database dev --sql "select * from stl_query limit 1"
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598306924.632, "Database": "dev", "DbUser": "myuser", "Id": "d9b6c0c9-0747-4bf4-b142-e8883122f766" }
如下所示 AWS CLI 指令會針對無伺服器工作群組執行SQL陳述式,並傳回識別碼以擷取結果。此範例使用暫時憑證身分驗證方法。
aws redshift-data execute-statement --database dev --workgroup-name myworkgroup --sql "select 1;"
以下是回應的範例。
{ "CreatedAt": "2022-02-11T06:25:28.748000+00:00", "Database": "dev", "DbUser": "IAMR:RoleName", "Id": "89dd91f5-2d43-43d3-8461-f33aa093c41e", "WorkgroupName": "myworkgroup" }
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,並傳回識別碼以擷取結果。此範例使用 AWS Secrets Manager 身份驗證方法和冪等令牌。
aws redshift-data execute-statement --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --sql "select * from stl_query limit 1" --database dev --client-token b855dced-259b-444c-bc7b-d3e8e33f94g1
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598323175.823, "Database": "dev", "Id": "c016234e-5c6c-4bc5-bb16-2c5b8ff61814", "SecretArn": "arn:aws:secretsmanager:us-west-2:123456789012:secret:yanruiz-secret-hKgPWn" }
若要執行含有參數的SQL陳述式
若要執行SQL陳述式,請使用 aws redshift-data execute-statement
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,並傳回識別碼以擷取結果。此範例使用 AWS Secrets Manager 驗證方法。SQL文本具有命名參數distance
。在此案例中,述詞中使用的距離是 5
。在SELECT陳述式中,資料行名稱的具名參數只能在述詞中使用。SQL陳述式的具名參數值會在parameters
選項中指定。
aws redshift-data execute-statement --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --sql "SELECT ratecode FROM demo_table WHERE trip_distance > :distance" --parameters "[{\"name\": \"distance\", \"value\": \"5\"}]" --database dev
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598323175.823, "Database": "dev", "Id": "c016234e-5c6c-4bc5-bb16-2c5b8ff61814", "SecretArn": "arn:aws:secretsmanager:us-west-2:123456789012:secret:yanruiz-secret-hKgPWn" }
下列範例會使用來自範例資料庫的 EVENT
資料表。如需詳細資訊,請參閱 Amazon Redshift 資料庫開發人員指南中的EVENT表格。
如果您的數據庫中還沒有EVENT
表,則可以使用數據創建一個表,API如下所示:
aws redshift-data execute-statement --database dev --cluster-id my-test-cluster --db-user awsuser --sql "create table event( eventid integer not null distkey, venueid smallint not null, catid smallint not null, dateid smallint not null sortkey, eventname varchar(200), starttime timestamp)"
下列命令會在 EVENT
資料表中插入一個資料列。
aws redshift-data execute-statement --database dev --cluster-id my-test-cluster --db-user awsuser --sql "insert into event values(:eventid, :venueid::smallint, :catid, :dateid, :eventname, :starttime)" --parameters "[{\"name\": \"eventid\", \"value\": \"1\"}, {\"name\": \"venueid\", \"value\": \"1\"}, {\"name\": \"catid\", \"value\": \"1\"}, {\"name\": \"dateid\", \"value\": \"1\"}, {\"name\": \"eventname\", \"value\": \"event 1\"}, {\"name\": \"starttime\", \"value\": \"2022-02-22\"}]"
下列命令會在 EVENT
資料表中插入第二個資料列。此範例示範下列操作:
-
名為
id
的參數會在SQL文字中使用四次。 -
在插入參數
starttime
時會自動套用隱含類型轉換。 -
該
venueid
列是類型轉換為SMALLINT數據類型。 -
代表DATE資料類型的字元字串會隱含轉換成TIMESTAMP資料類型。
-
註解可以在SQL文字中使用。
aws redshift-data execute-statement --database dev --cluster-id my-test-cluster --db-user awsuser --sql "insert into event values(:id, :id::smallint, :id, :id, :eventname, :starttime) /*this is comment, and it won't apply parameterization for :id, :eventname or :starttime here*/" --parameters "[{\"name\": \"eventname\", \"value\": \"event 2\"}, {\"name\": \"starttime\", \"value\": \"2022-02-22\"}, {\"name\": \"id\", \"value\": \"2\"}]"
下列範例顯示所插入的兩個資料列:
eventid | venueid | catid | dateid | eventname | starttime ---------+---------+-------+--------+-----------+--------------------- 1 | 1 | 1 | 1 | event 1 | 2022-02-22 00:00:00 2 | 2 | 2 | 2 | event 2 | 2022-02-22 00:00:00
下列命令會在WHERE子句中使用具名參數來擷取其eventid
中的資料列1
。
aws redshift-data execute-statement --database dev --cluster-id my-test-cluster --db-user awsuser --sql "select * from event where eventid=:id" --parameters "[{\"name\": \"id\", \"value\": \"1\"}]"
執行下列命令以取得上一個SQL陳述式的SQL結果:
aws redshift-data get-statement-result --id 7529ad05-b905-4d71-9ec6-8b333836eb5a
提供下列結果:
{ "Records": [ [ { "longValue": 1 }, { "longValue": 1 }, { "longValue": 1 }, { "longValue": 1 }, { "stringValue": "event 1" }, { "stringValue": "2022-02-22 00:00:00.0" } ] ], "ColumnMetadata": [ { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "eventid", "length": 0, "name": "eventid", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "public", "tableName": "event", "typeName": "int4" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "venueid", "length": 0, "name": "venueid", "nullable": 0, "precision": 5, "scale": 0, "schemaName": "public", "tableName": "event", "typeName": "int2" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "catid", "length": 0, "name": "catid", "nullable": 0, "precision": 5, "scale": 0, "schemaName": "public", "tableName": "event", "typeName": "int2" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "dateid", "length": 0, "name": "dateid", "nullable": 0, "precision": 5, "scale": 0, "schemaName": "public", "tableName": "event", "typeName": "int2" }, { "isCaseSensitive": true, "isCurrency": false, "isSigned": false, "label": "eventname", "length": 0, "name": "eventname", "nullable": 1, "precision": 200, "scale": 0, "schemaName": "public", "tableName": "event", "typeName": "varchar" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "label": "starttime", "length": 0, "name": "starttime", "nullable": 1, "precision": 29, "scale": 6, "schemaName": "public", "tableName": "event", "typeName": "timestamp" } ], "TotalNumRows": 1 }
若要執行多個SQL陳述式
若要使用一個命令執行多個SQL陳述式,請使用 aws redshift-data
batch-execute-statement
AWS CLI 指令。
如下所示 AWS CLI 命令對一個群集運行三個SQL語句,並返回一個標識符來獲取結果。此範例使用暫時憑證身分驗證方法。
aws redshift-data batch-execute-statement --region us-west-2 --db-user myuser --cluster-identifier mycluster-test --database dev --sqls "set timezone to BST" "select * from mytable" "select * from another_table"
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598306924.632, "Database": "dev", "DbUser": "myuser", "Id": "d9b6c0c9-0747-4bf4-b142-e8883122f766" }
列出SQL敘述句的詮釋資料
若要列出SQL陳述式的中繼資料,請使用 aws redshift-data
list-statements
AWS CLI 指令。執行此命令的授權取決於呼叫者的IAM權限。
如下所示 AWS CLI 指令會列出執行的SQL陳述式。
aws redshift-data list-statements --region us-west-2 --status ALL
以下是回應的範例。
{ "Statements": [ { "CreatedAt": 1598306924.632, "Id": "d9b6c0c9-0747-4bf4-b142-e8883122f766", "QueryString": "select * from stl_query limit 1", "Status": "FINISHED", "UpdatedAt": 1598306926.667 }, { "CreatedAt": 1598311717.437, "Id": "e0ebd578-58b3-46cc-8e52-8163fd7e01aa", "QueryString": "select * from stl_query limit 1", "Status": "FAILED", "UpdatedAt": 1598311719.008 }, { "CreatedAt": 1598313683.65, "Id": "c361d4f7-8c53-4343-8c45-6b2b1166330c", "QueryString": "select * from stl_query limit 1", "Status": "ABORTED", "UpdatedAt": 1598313685.495 }, { "CreatedAt": 1598306653.333, "Id": "a512b7bd-98c7-45d5-985b-a715f3cfde7f", "QueryString": "select 1", "Status": "FINISHED", "UpdatedAt": 1598306653.992 } ] }
描述陳述SQL式的中繼資料
若要取得陳述式中繼資料的描SQL述,請使用 aws
redshift-data describe-statement
AWS CLI 指令。執行此命令的授權取決於呼叫者的IAM權限。
如下所示 AWS CLI 命令描述了一個SQL語句。
aws redshift-data describe-statement --id d9b6c0c9-0747-4bf4-b142-e8883122f766 --region us-west-2
以下是回應的範例。
{ "ClusterIdentifier": "mycluster-test", "CreatedAt": 1598306924.632, "Duration": 1095981511, "Id": "d9b6c0c9-0747-4bf4-b142-e8883122f766", "QueryString": "select * from stl_query limit 1", "RedshiftPid": 20859, "RedshiftQueryId": 48879, "ResultRows": 1, "ResultSize": 4489, "Status": "FINISHED", "UpdatedAt": 1598306926.667 }
以下是執行含有多個SQL陳述式的batch-execute-statement
命令之後的describe-statement
回應範例。
{ "ClusterIdentifier": "mayo", "CreatedAt": 1623979777.126, "Duration": 6591877, "HasResultSet": true, "Id": "b2906c76-fa6e-4cdf-8c5f-4de1ff9b7652", "RedshiftPid": 31459, "RedshiftQueryId": 0, "ResultRows": 2, "ResultSize": 22, "Status": "FINISHED", "SubStatements": [ { "CreatedAt": 1623979777.274, "Duration": 3396637, "HasResultSet": true, "Id": "b2906c76-fa6e-4cdf-8c5f-4de1ff9b7652:1", "QueryString": "select 1;", "RedshiftQueryId": -1, "ResultRows": 1, "ResultSize": 11, "Status": "FINISHED", "UpdatedAt": 1623979777.903 }, { "CreatedAt": 1623979777.274, "Duration": 3195240, "HasResultSet": true, "Id": "b2906c76-fa6e-4cdf-8c5f-4de1ff9b7652:2", "QueryString": "select 2;", "RedshiftQueryId": -1, "ResultRows": 1, "ResultSize": 11, "Status": "FINISHED", "UpdatedAt": 1623979778.076 } ], "UpdatedAt": 1623979778.183 }
若要擷取SQL陳述式的結果
若要從執行的SQL陳述式擷取結果,請使用 redshift-data
get-statement-result
AWS CLI 指令。您可以提供所收到的 Id
以回應 execute-statement
或 batch-execute-statement
。執行之SQL陳述式的Id
值batch-execute-statement
可以在的結果中擷取,describe-statement
並加上冒號和序號 (例如) 後綴。b2906c76-fa6e-4cdf-8c5f-4de1ff9b7652:2
如果您使用執行多個SQL陳述式batch-execute-statement
,則每個SQL陳述式都有一個Id
值,如中所示describe-statement
。執行此命令的授權取決於呼叫者的IAM權限。
下列陳述式會傳回執行之SQL陳述式的結果execute-statement
。
aws redshift-data get-statement-result --id d9b6c0c9-0747-4bf4-b142-e8883122f766 --region us-west-2
下列陳述式會傳回執行之第二個SQL陳述式的結果batch-execute-statement
。
aws redshift-data get-statement-result --id b2906c76-fa6e-4cdf-8c5f-4de1ff9b7652:2 --region us-west-2
以下是對於 get-statement-result
呼叫的回應範例。
{ "ColumnMetadata": [ { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "userid", "length": 0, "name": "userid", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "query", "length": 0, "name": "query", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" }, { "isCaseSensitive": true, "isCurrency": false, "isSigned": false, "label": "label", "length": 0, "name": "label", "nullable": 0, "precision": 320, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "bpchar" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "xid", "length": 0, "name": "xid", "nullable": 0, "precision": 19, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int8" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "pid", "length": 0, "name": "pid", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" }, { "isCaseSensitive": true, "isCurrency": false, "isSigned": false, "label": "database", "length": 0, "name": "database", "nullable": 0, "precision": 32, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "bpchar" }, { "isCaseSensitive": true, "isCurrency": false, "isSigned": false, "label": "querytxt", "length": 0, "name": "querytxt", "nullable": 0, "precision": 4000, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "bpchar" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "label": "starttime", "length": 0, "name": "starttime", "nullable": 0, "precision": 29, "scale": 6, "schemaName": "", "tableName": "stll_query", "typeName": "timestamp" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "label": "endtime", "length": 0, "name": "endtime", "nullable": 0, "precision": 29, "scale": 6, "schemaName": "", "tableName": "stll_query", "type": 93, "typeName": "timestamp" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "aborted", "length": 0, "name": "aborted", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "insert_pristine", "length": 0, "name": "insert_pristine", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": true, "label": "concurrency_scaling_status", "length": 0, "name": "concurrency_scaling_status", "nullable": 0, "precision": 10, "scale": 0, "schemaName": "", "tableName": "stll_query", "typeName": "int4" } ], "Records": [ [ { "longValue": 1 }, { "longValue": 3 }, { "stringValue": "health" }, { "longValue": 1023 }, { "longValue": 15279 }, { "stringValue": "dev" }, { "stringValue": "select system_status from stv_gui_status;" }, { "stringValue": "2020-08-21 17:33:51.88712" }, { "stringValue": "2020-08-21 17:33:52.974306" }, { "longValue": 0 }, { "longValue": 0 }, { "longValue": 6 } ] ], "TotalNumRows": 1 }
描述資料表
若要取得描述資料表的中繼資料,請使用 aws redshift-data
describe-table
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,並傳回描述資料表的中繼資料。此範例使用 AWS Secrets Manager 驗證方法。
aws redshift-data describe-table --region us-west-2 --cluster-identifier mycluster-test --database dev --schema information_schema --table sql_features --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn
以下是回應的範例。
{ "ColumnList": [ { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "feature_id", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "feature_name", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" } ] }
如下所示 AWS CLI 命令會針對描述資料表的叢集執行SQL陳述式。此範例使用暫時憑證身分驗證方法。
aws redshift-data describe-table --region us-west-2 --db-user myuser --cluster-identifier mycluster-test --database dev --schema information_schema --table sql_features
以下是回應的範例。
{ "ColumnList": [ { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "feature_id", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "feature_name", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "sub_feature_id", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "sub_feature_name", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "is_supported", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "is_verified_by", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" }, { "isCaseSensitive": false, "isCurrency": false, "isSigned": false, "length": 2147483647, "name": "comments", "nullable": 1, "precision": 2147483647, "scale": 0, "schemaName": "information_schema", "tableName": "sql_features", "typeName": "character_data" } ] }
列出叢集中的資料庫
若要列出叢集中的資料庫,請使用 aws redshift-data
list-databases
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式以列出資料庫。此範例使用 AWS Secrets Manager 驗證方法。
aws redshift-data list-databases --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --database dev
以下是回應的範例。
{ "Databases": [ "dev" ] }
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式以列出資料庫。此範例使用暫時憑證身分驗證方法。
aws redshift-data list-databases --region us-west-2 --db-user myuser --cluster-identifier mycluster-test --database dev
以下是回應的範例。
{ "Databases": [ "dev" ] }
列出資料庫中的結構描述
若要列出資料庫中的結構描述,請使用 aws redshift-data
list-schemas
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,以列出資料庫中的結構描述。此範例使用 AWS Secrets Manager 驗證方法。
aws redshift-data list-schemas --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --database dev
以下是回應的範例。
{ "Schemas": [ "information_schema", "pg_catalog", "pg_internal", "public" ] }
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,以列出資料庫中的結構描述。此範例使用暫時憑證身分驗證方法。
aws redshift-data list-schemas --region us-west-2 --db-user mysuser --cluster-identifier mycluster-test --database dev
以下是回應的範例。
{ "Schemas": [ "information_schema", "pg_catalog", "pg_internal", "public" ] }
列出資料庫中的資料表
若要列出資料庫中的表格,請使用 aws redshift-data
list-tables
AWS CLI 指令。
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,以列出資料庫中的表格。此範例使用 AWS Secrets Manager 驗證方法。
aws redshift-data list-tables --region us-west-2 --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn --cluster-identifier mycluster-test --database dev --schema information_schema
以下是回應的範例。
{ "Tables": [ { "name": "sql_features", "schema": "information_schema", "type": "SYSTEM TABLE" }, { "name": "sql_implementation_info", "schema": "information_schema", "type": "SYSTEM TABLE" } }
如下所示 AWS CLI 命令會針對叢集執行SQL陳述式,以列出資料庫中的表格。此範例使用暫時憑證身分驗證方法。
aws redshift-data list-tables --region us-west-2 --db-user myuser --cluster-identifier mycluster-test --database dev --schema information_schema
以下是回應的範例。
{ "Tables": [ { "name": "sql_features", "schema": "information_schema", "type": "SYSTEM TABLE" }, { "name": "sql_implementation_info", "schema": "information_schema", "type": "SYSTEM TABLE" } ] }