AWS閉鎖網+Snowflake JDBCドライバにて接続する場合

Last updated at 2026-10-21Posted at 2026-10-18

今回はAWS閉鎖網にて、JDBCドライバの設定をし、簡単なjavaにて接続を試してみます。

環境

下記の続きです。

・AWS閉鎖網+Snowflake Private Link
https://qiita.com/Cache-Hit/items/5f7f8788b4d97d4b553d

・AWS閉鎖網+Snowflake 内部ステージのS3への接続設定
https://qiita.com/Cache-Hit/items/61a5aac9a66bda5f0aa8

・AWS閉鎖網+Snowflake 自動起動無効にした場合のDWHについて
https://qiita.com/Cache-Hit/items/822de53aa7e97d65d097

JBDCドライバ配置

Cliud Shellにて秘密鍵作成

~ $ cd ~/snowflake-keys
bash: cd: /home/cloudshell-user/snowflake-keys: No such file or directory
~ $ 
~ $ openssl genpkey \
>   -algorithm RSA \
>   -pkeyopt rsa_keygen_bits:3072 \
>   -aes-256-cbc \
>   -out rsa_key.p8
......+.................+.........+......++++++++++++++++++++++++++++++++++++++++++*.........+..+....+...+.....++++++++++++++++++++++++++++++++++++++++++*......+.+........+...+...................+.....+................+.....+.......+..+...+..........+........+....+.........+......+........+...+...+....+........+...+.+...........+.......+...+...+..+....+.....+...+......+....+.....+.............+........+.+........+............+..........+.........+..+..........+..+...+.........+................+........+.........+.+.....+.+.....+.+++++
...........+...+......+.+........+...+....+......+...+......+...............+.....+..........+..................+...+............+..+...+...+...+............+....+...+......+.....+.+.....+.........+.+...+...+............+........+.......+......+.........+..++++++++++++++++++++++++++++++++++++++++++*..+...+.+......+...++++++++++++++++++++++++++++++++++++++++++*.........+.............+...+..+...+............+.............+.....+......+..................+.......+...+...+...+......+.........+.....+......+......+..................+.+...........+............+.......+.....+.........+....+.....+.............+...+.................+..........+..+......+......+.+...............+............+...................................+.......+.........+......+........+......+......+....+...........+....+......+...........+............+.......+...+............+......+...+..+....+.....+...+...+.......+...........+....+..+...+...+.........+....+..+....+...+......+.....+.........+......+............+...+................+...+...........+...................+..+....+..+...+.+...+........+.........+.........+......+...+.............+..+..................+.......+..+......+.......+..+...+...+...+............+..........+...+..............+..........+.................+................+..+.+......+...............+......+..+...+..........+.........+.....+...............+.+........+......+......+...+....+........+.........+......+....+...+...........+.......+...+..............+.+.....+.+...+.....+...+...+...................+......+......+...........+...+.+.........+..+..................+............+.........+.+.....+....+.....+....+...........+..................+.+.........+...+...+..+..........+..+......................+...........+.......+......+...........+.+.....+.......+...............+........+..................+.+....................+...+..........+...+...+..+...+.........+............+...+...+...................+...+..............................+........+.............+...............+...........+...+..........+...........+.+.....+++++
Enter PEM pass phrase:
Verifying - Enter PEM pass phrase:
~ $

確認

~ $ ll  rsa_key.p8
-rw-------. 1 cloudshell-user cloudshell-user 2666 Oct 18 08:09 rsa_key.p8

公開鍵を生成

~ $ ll  rsa_key.p8
-rw-------. 1 cloudshell-user cloudshell-user 2666 Oct 18 08:09 rsa_key.p8
~ $ head -n 1 rsa_key.p8
-----BEGIN ENCRYPTED PRIVATE KEY-----
~ $ openssl pkey \
>   -in rsa_key.p8 \
>   -pubout \
>   -out rsa_key.pub
Enter pass phrase for rsa_key.p8:
~ $

結果を確認

~ $ ls -l rsa_key.p8 rsa_key.pub
-rw-------. 1 cloudshell-user cloudshell-user 2666 Oct 18 08:09 rsa_key.p8
-rw-r--r--. 1 cloudshell-user cloudshell-user  625 Oct 18 08:14 rsa_key.pub

作成した秘密鍵をダウンロード

ユーザの作成とアタッチ

★Snowsightにて作業

・ロールを切り替え

USE ROLE ACCOUNTADMIN;

JDBC接続専用ロールを作成

CREATE ROLE IF NOT EXISTS ROLE_SNOWFLAKE_JDBC;

JDBC接続専用サービスユーザーを作成。

CREATE USER IF NOT EXISTS SVC_SNOWFLAKE_JDBC 
    TYPE = SERVICE
    DEFAULT_ROLE = ROLE_SNOWFLAKE_JDBC
    DEFAULT_WAREHOUSE = SNOWTESTSFLAKE
    DEFAULT_NAMESPACE = SNOWTESTDB.TEST_SCHEMA
    COMMENT = 'Service user for JDBC 4.4.0 via AWS PrivateLink';

・サービスユーザ名
SVC_SNOWFLAKE_JDBC

・タイプ
サービス(Snowsightログイン不可)

・デフォルトロール
先ほど作ったROLE_SNOWFLAKE_JDBCを指定

・デフォルトウェアハウス
SNOWTESTSFLAKEを指定

・デフォルトのテーブル
SNOWTESTDB.TEST_SCHEMA

作成したユーザにロールをアタッチ

GRANT ROLE ROLE_SNOWFLAKE_JDBC
    TO USER SVC_SNOWFLAKE_JDBC;

ウェアハウスの使用権限付与

GRANT USAGE ON WAREHOUSE SNOWTESTSFLAKE
    TO ROLE ROLE_SNOWFLAKE_JDBC;

データベースの使用権限

GRANT USAGE ON DATABASE SNOWTESTDB
    TO ROLE ROLE_SNOWFLAKE_JDBC;

スキーマの使用権限

GRANT USAGE ON SCHEMA SNOWTESTDB.TEST_SCHEMA
    TO ROLE ROLE_SNOWFLAKE_JDBC;

既存テーブルのSELECT権限

GRANT SELECT ON ALL TABLES IN SCHEMA SNOWTESTDB.TEST_SCHEMA
    TO ROLE ROLE_SNOWFLAKE_JDBC;

CloudShellの公開鍵をSnowflakeに登録

-----BEGIN PUBLIC KEY----- や -----END PUBLIC KEY----- は除きます。

ALTER USER SVC_SNOWFLAKE_JDBC
SET RSA_PUBLIC_KEY = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX=';

ユーザーと公開鍵の登録状態を確認

DESC USER SVC_SNOWFLAKE_JDBC;

結果
No	Property	VALUE	default
1	NAME	SVC_SNOWFLAKE_JDBC	null
2	COMMENT	Service user for JDBC 4.4.0 via AWS PrivateLink	null
3	DISPLAY_NAME	SVC_SNOWFLAKE_JDBC	null
4	TYPE	SERVICE	null
5	LOGIN_NAME	SVC_SNOWFLAKE_JDBC	null
6	FIRST_NAME	null	null
7	MIDDLE_NAME	null	null
8	LAST_NAME	null
9	EMAIL	null	null
10	PASSWORD	null	null
11	MUST_CHANGE_PASSWORD	false	false
12	DISABLED	false	false
13	SNOWFLAKE_LOCK	false	false
14	SNOWFLAKE_SUPPORT	false	false
15	DAYS_TO_EXPIRY	null	null
16	MINS_TO_UNLOCK	null	null
17	DEFAULT_WAREHOUSE	SNOWTESTSFLAKE	null
18	DEFAULT_NAMESPACE	SNOWTESTDB.TEST_SCHEMA	null
19	DEFAULT_ROLE	ROLE_SNOWFLAKE_JDBC	null
20	DEFAULT_SECONDARY_ROLES	["ALL"]	[ALL]
21	EXT_AUTHN_DUO	false	false
22	EXT_AUTHN_UID	null	null
23	DEFAULT_MFA_METHOD	null	null
24	HAS_MFA	false	false
25	HAS_PAT	false	false
26	HAS_WORKLOAD_IDENTITY	false	false
27	HAS_KEYPAIR	true	false
28	IS_EMAIL_VERIFIED	false	false
29	MINS_TO_BYPASS_MFA	null	null
30	MINS_TO_BYPASS_NETWORK_POLICY	null	null
31	RSA_PUBLIC_KEY	XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX=	null
32	RSA_PUBLIC_KEY_FP	SHA256:pK/UXEnDMJJIicOC9PEMHHXjGvLnycEdKpsPdjQE8WI=	null
33	RSA_PUBLIC_KEY_LAST_SET_TIME	2026-10-19 06:50:09.208	null
34	RSA_PUBLIC_KEY_2	null
35	RSA_PUBLIC_KEY_2_FP	null	null
36	RSA_PUBLIC_KEY_2_LAST_SET_TIME	null	null
37	SCIM_USER_NAME	null	null
38	PASSWORD_LAST_SET_TIME	null	null
39	MINS_TO_BYPASS_SESSION_POLICY	null	null
40	CUSTOM_LANDING_PAGE_URL	null	null
41	CUSTOM_LANDING_PAGE_URL_FLUSH_NEXT_UI_LOAD	false	false
42	IS_FROM_ORGANIZATION_USER	false	false
43	ALLOWED_INTERFACES	[ALL]	null
44	LOCK_DETAILS	{"isAdminLocked":false,"isMfaLocked":false,"isMfaOTPLocked":false,"isMfaTOTPLocked":false,"isPasswordLocked":false,"isSnowflakeLocked":false}	null

秘密鍵をEC2を設定

C:\Users\Administrator>aws s3 cp s3://snowtestsflake/Shizai/rsa_key.p8 C:\Users\Administrator\Desktop\
download: s3://snowtestsflake/Shizai/rsa_key.p8 to Desktop\rsa_key.p8

C:\Users\Administrator>aws s3 cp s3://snowtestsflake/Shizai/rsa_key.pub C:\Users\Administrator\Desktop\
download: s3://snowtestsflake/Shizai/rsa_key.pub to Desktop\rsa_key.pub

ロールを切り替え

USE ROLE ACCOUNTADMIN;

JDBC検証専用テーブルを作成

CREATE TABLE IF NOT EXISTS
SNOWTESTDB.TEST_SCHEMA.JDBC_TEST_TABLE (
    ID NUMBER,
    NAME VARCHAR(100),
    CREATED_AT TIMESTAMP_NTZ DEFAULT CURRENT_TIMESTAMP()
);

JDBC用ロールに必要な権限を付与

GRANT SELECT, INSERT, UPDATE, DELETE
ON TABLE SNOWTESTDB.TEST_SCHEMA.JDBC_TEST_TABLE
TO ROLE ROLE_SNOWFLAKE_JDBC;

Windows EC2に秘密鍵とJDBCドライバーを配置

 C:\snowflake-jdbc\SnowflakeJdbcWriteTest.javakeys のディレクトリ

2026/10/19  17:18    <DIR>          .
2026/10/19  17:18    <DIR>          ..
2026/10/19  16:26             2,666 rsa_key.p8
               1 個のファイル               2,666 バイト
               2 個のディレクトリ  27,482,898,432 バイトの空き領域


C:\Users\Administrator>dir C:\snowflake-jdbc\
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/19  17:18    <DIR>          .
2026/10/15  20:52        98,569,339 snowflake-jdbc-4.4.0.jar
2026/10/19  17:18    <DIR>          SnowflakeJdbcWriteTest.javakeys
               1 個のファイル          98,569,339 バイト
               2 個のディレクトリ  27,482,898,432 バイトの空き領域

配置ファイルの確認

PS C:\Windows\system32> Test-Path "C:\snowflake-jdbc\snowflake-jdbc-4.4.0.jar"
True
PS C:\Windows\system32> Test-Path "C:\snowflake-jdbc\keys\rsa_key.p8"
True

環境変数を設定

C:\Users\Administrator>where java
C:\Program Files (x86)\Common Files\Oracle\Java\javapath\java.exe
C:\Program Files (x86)\Java\jdk1.8.0_281\bin\java.exe

C:\Users\Administrator>where javac
C:\Program Files (x86)\Java\jdk1.8.0_281\bin\javac.exe

C:\Users\Administrator>javac -version
javac 1.8.0_281

C:\Users\Administrator>

配置しているフォルダを確認。

C:\Users\Administrator>dir C:\snowflake-jdbc\snowflake-jdbc-4.4.0.jar
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/15  20:52        98,569,339 snowflake-jdbc-4.4.0.jar
               1 個のファイル          98,569,339 バイト
               0 個のディレクトリ  27,178,246,144 バイトの空き領域

Javaプログラム用のパスフレーズを記載するファイルを作成

notepad C:\snowflake-jdbc\jdbc-secret.properties

下記を記載します。

private_key_pwd=ここに実際のRSA秘密鍵のパスフレーズを入力

Javaプログラムを作成

notepad C:\snowflake-jdbc\SnowflakeJdbcTest.java

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import java.security.Security;
import org.bouncycastle.jce.provider.BouncyCastleProvider;

public class SnowflakeJdbcTest {
    public static void main(String[] args) {
        long start = System.nanoTime();
        boolean connected = false;
        boolean selected = false;
        String user = "-", role = "-", db = "-", schema = "-", version = "-";

        System.out.println("==================================================");
        System.out.println(" SNOWFLAKE JDBC CONNECTION TEST");
        System.out.println("==================================================");
        System.out.println("Java Version       : " + System.getProperty("java.version"));
        System.out.println("JDBC Driver        : Snowflake JDBC 4.4.0");
        System.out.println("Authentication     : RSA Key Pair (Encrypted)");
        System.out.println("Connection         : AWS PrivateLink");
        System.out.println();

        try {
            Security.addProvider(new BouncyCastleProvider());
            Properties secrets = new Properties();
            try (FileInputStream fis = new FileInputStream("C:/snowflake-jdbc/jdbc-secret.properties")) {
                secrets.load(fis);
            }
            String passphrase = secrets.getProperty("private_key_pwd");
            if (passphrase == null || passphrase.isEmpty()) {
                throw new IllegalStateException("Private key passphrase is missing.");
            }

            Properties props = new Properties();
            props.put("user", "SVC_SNOWFLAKE_JDBC");
            props.put("authenticator", "snowflake_jwt");
            props.put("private_key_file", "C:/snowflake-jdbc/keys/rsa_key.p8");
            props.put("private_key_pwd", passphrase);
            props.put("warehouse", "SNOWTESTSFLAKE");
            props.put("db", "SNOWTESTDB");
            props.put("schema", "TEST_SCHEMA");
            props.put("role", "ROLE_SNOWFLAKE_JDBC");

            String url = "jdbc:snowflake://HK33186.ap-northeast-1.privatelink.snowflakecomputing.com:443/";
            System.out.println("[1] Connecting to Snowflake...");
            try (Connection conn = DriverManager.getConnection(url, props)) {
                connected = true;
                System.out.println("    Result         : SUCCESS");
                System.out.println();
                System.out.println("[2] Checking session and running SELECT...");
                String sql = "SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_DATABASE(), "
                        + "CURRENT_SCHEMA(), CURRENT_VERSION()";
                try (Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql)) {
                    if (!rs.next()) throw new IllegalStateException("SELECT returned no rows.");
                    user = rs.getString(1);
                    role = rs.getString(2);
                    db = rs.getString(3);
                    schema = rs.getString(4);
                    version = rs.getString(5);
                    selected = true;
                }
                System.out.println("    User           : " + user);
                System.out.println("    Role           : " + role);
                System.out.println("    Database       : " + db);
                System.out.println("    Schema         : " + schema);
                System.out.println("    Snowflake Ver. : " + version);
                System.out.println("    SELECT Result  : SUCCESS");
            }
        } catch (Exception e) {
            System.out.println("    Result         : FAILED");
            System.err.println("Test error: " + e.getClass().getSimpleName() + ": " + e.getMessage());
        }

        double seconds = (System.nanoTime() - start) / 1_000_000_000.0;
        System.out.println();
        System.out.println("--------------------------------------------------");
        System.out.println(" OVERALL RESULT    : " + (connected && selected ? "SUCCESS" : "FAILED"));
        System.out.printf(java.util.Locale.US, " Elapsed Time      : %.2f seconds%n", seconds);
        System.out.println("==================================================");
        if (!connected || !selected) System.exit(1);
    }
}

作成したファイルを確認

C:\Users\Administrator>dir C:\snowflake-jdbc\jdbc-secret.properties
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/19  23:23                20 jdbc-secret.properties
               1 個のファイル                  20 バイト
               0 個のディレクトリ  27,178,090,496 バイトの空き領域

C:\Users\Administrator>dir C:\snowflake-jdbc\SnowflakeJdbcTest.java
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/19  23:24             2,409 SnowflakeJdbcTest.java
               1 個のファイル               2,409 バイト
               0 個のディレクトリ  27,178,090,496 バイトの空き領域

C:\Users\Administrator>dir C:\snowflake-jdbc\keys\rsa_key.p8
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc\keys のディレクトリ

2026/10/19  16:26             2,666 rsa_key.p8
               1 個のファイル               2,666 バイト
               0 個のディレクトリ  27,178,029,056 バイトの空き領域

C:\Users\Administrator>dir C:\snowflake-jdbc\snowflake-jdbc-4.4.0.jar
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/15  20:52        98,569,339 snowflake-jdbc-4.4.0.jar
               1 個のファイル          98,569,339 バイト
               0 個のディレクトリ  27,178,029,056 バイトの空き領域

Javaプログラムをコンパイル

C:\snowflake-jdbc>javac -encoding UTF-8 -cp ".;snowflake-jdbc-4.4.0.jar" SnowflakeJdbcTest.java

C:\snowflake-jdbc>

コンパイル結果を確認

 C:\snowflake-jdbc のディレクトリ

2026/10/19  23:29             3,553 SnowflakeJdbcTest.class
               1 個のファイル               3,553 バイト
               0 個のディレクトリ  27,176,452,096 バイトの空き領域

下記からBouncy Castleをダウンロード

★cloudShellで実行してS3に送るか、自PCからダウンロードしてEC2に送る。

https://repo.maven.apache.org/maven2/org/bouncycastle/bcprov-jdk15to18/1.78.1/bcprov-jdk15to18-1.78.1.jar

所定フォルダへダウンロードと確認

C:\snowflake-jdbc>aws s3 cp s3://snowtestsflake/Shizai/bcprov-jdk15to18-1.78.1.jar C:\snowflake-jdbc\
download: s3://snowtestsflake/Shizai/bcprov-jdk15to18-1.78.1.jar to .\bcprov-jdk15to18-1.78.1.jar

C:\snowflake-jdbc>dir C:\snowflake-jdbc\bcprov*.jar
 ドライブ C のボリューム ラベルは Windows です
 ボリューム シリアル番号は D4C7-F9D3 です

 C:\snowflake-jdbc のディレクトリ

2026/10/19  23:46         6,638,538 bcprov-jdk15to18-1.78.1.jar
               1 個のファイル           6,638,538 バイト
               0 個のディレクトリ  27,169,525,760 バイトの空き領域

ディレクトリ移動

cd /d C:\snowflake-jdbc

コンパイル

C:\snowflake-jdbc>javac -encoding UTF-8 -cp ".;snowflake-jdbc-4.4.0.jar;bcprov-jdk15to18-1.78.1.jar" SnowflakeJdbcTest.java

実行結果をファイルに保存

java -cp ".;snowflake-jdbc-4.4.0.jar;bcprov-jdk15to18-1.78.1.jar" SnowflakeJdbcTest > connection-test.log 2>&1

結果を確認

notepad C:\snowflake-jdbc\connection-test.log

接続がうまくいきました。

==================================================
 SNOWFLAKE JDBC CONNECTION TEST
==================================================
Java Version       : 1.8.0_281
JDBC Driver        : Snowflake JDBC 4.4.0
Authentication     : RSA Key Pair (Encrypted)
Connection         : AWS PrivateLink

[1] Connecting to Snowflake...
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:04 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content: 
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content: 
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 20, 2026 12:01:04 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,046 ms, timeout: 1,000 ms
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal HTTP/1.1
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,047 ms, timeout: 1,000 ms
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal/computeMetadata/v1/instance/service-accounts/default/email HTTP/1.1
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,059 ms, timeout: 1,000 ms
10 20, 2026 12:01:05 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: PUT http://[fd00:ec2::254]/latest/api/token HTTP/1.1
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:05 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 20, 2026 12:01:06 午前 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 20, 2026 12:01:06 午前 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,069 ms, timeout: 1,000 ms
10 20, 2026 12:01:06 午前 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: GET http://[fd00:ec2::254]/latest/dynamic/instance-identity/document HTTP/1.1
    Result         : SUCCESS

[2] Checking session and running SELECT...
    User           : SVC_SNOWFLAKE_JDBC
    Role           : ROLE_SNOWFLAKE_JDBC
    Database       : SNOWTESTDB
    Schema         : TEST_SCHEMA
    Snowflake Ver. : 10.37.102
    SELECT Result  : SUCCESS

--------------------------------------------------
 OVERALL RESULT    : SUCCESS
 Elapsed Time      : 7.29 seconds
==================================================

テストファイルを設置

C:\snowflake-jdbcRunSnowflakeAudit.bat

@echo off
setlocal
cd /d C:\snowflake-jdbc
set "CP=.;snowflake-jdbc-4.4.0.jar;bcprov-jdk15to18-1.78.1.jar"
if not exist "SnowflakeAuditTest.java" (
  echo ERROR: SnowflakeAuditTest.java not found.
  exit /b 1
)
if not exist "snowflake-jdbc-4.4.0.jar" (
  echo ERROR: JDBC JAR not found.
  exit /b 1
)
if not exist "bcprov-jdk15to18-1.78.1.jar" (
  echo ERROR: Bouncy Castle JAR not found.
  exit /b 1
)
echo Compiling SnowflakeAuditTest.java ...
javac -encoding UTF-8 -cp "%CP%" SnowflakeAuditTest.java
if errorlevel 1 exit /b 1
echo Running Snowflake audit report ...
java -cp "%CP%" SnowflakeAuditTest > "snowflake-audit.log" 2>&1
set "RC=%ERRORLEVEL%"
type "snowflake-audit.log"
echo.
echo Report saved: C:\snowflake-jdbc\snowflake-audit.log
exit /b %RC%

C:\snowflake-jdbc\SnowflakeAuditTest.java

import java.io.FileInputStream;
import java.security.Security;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import org.bouncycastle.jce.provider.BouncyCastleProvider;

public class SnowflakeAuditTest {
    private static final String URL = "jdbc:snowflake://HK33186.ap-northeast-1.privatelink.snowflakecomputing.com:443/";

    public static void main(String[] args) {
        long start = System.currentTimeMillis();
        System.out.println("============================================================");
        System.out.println(" SNOWFLAKE JDBC QUERY HISTORY REPORT");
        System.out.println("============================================================");
        System.out.println("Scope  : Current service user, last 24 hours");
        System.out.println("Mode   : Read only (SELECT)");
        System.out.println();
        try {
            Security.addProvider(new BouncyCastleProvider());
            Properties secrets = new Properties();
            try (FileInputStream in = new FileInputStream("C:/snowflake-jdbc/jdbc-secret.properties")) {
                secrets.load(in);
            }
            String passphrase = secrets.getProperty("private_key_pwd");
            if (passphrase == null || passphrase.isEmpty()) {
                throw new IllegalStateException("private_key_pwd is missing");
            }
            Properties props = new Properties();
            props.setProperty("user", "SVC_SNOWFLAKE_JDBC");
            props.setProperty("authenticator", "snowflake_jwt");
            props.setProperty("private_key_file", "C:/snowflake-jdbc/keys/rsa_key.p8");
            props.setProperty("private_key_pwd", passphrase);
            props.setProperty("warehouse", "SNOWTESTSFLAKE");
            props.setProperty("db", "SNOWTESTDB");
            props.setProperty("schema", "TEST_SCHEMA");
            props.setProperty("role", "ROLE_SNOWFLAKE_JDBC");

            try (Connection conn = DriverManager.getConnection(URL, props)) {
                System.out.println("[1] Connection          : SUCCESS");
                String sessionSql = "SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_WAREHOUSE(), " +
                        "CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_TIMESTAMP()";
                try (Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sessionSql)) {
                    if (rs.next()) {
                        System.out.println("    User               : " + rs.getString(1));
                        System.out.println("    Role               : " + rs.getString(2));
                        System.out.println("    Warehouse          : " + rs.getString(3));
                        System.out.println("    Database           : " + rs.getString(4));
                        System.out.println("    Schema             : " + rs.getString(5));
                        System.out.println("    Snowflake time     : " + rs.getString(6));
                    }
                }
                System.out.println();
                System.out.println("[2] Query history (last 24 hours, up to 100 recent queries)");
                String historySql =
                    "SELECT START_TIME, QUERY_TYPE, EXECUTION_STATUS, WAREHOUSE_NAME, " +
                    "DATABASE_NAME, SCHEMA_NAME, TOTAL_ELAPSED_TIME, QUERY_ID, QUERY_TEXT " +
                    "FROM TABLE(SNOWTESTDB.INFORMATION_SCHEMA.QUERY_HISTORY(" +
                    "END_TIME_RANGE_START => DATEADD('HOUR', -24, CURRENT_TIMESTAMP()), " +
                    "RESULT_LIMIT => 100)) " +
                    "WHERE USER_NAME = CURRENT_USER() ORDER BY START_TIME DESC";
                int count = 0;
                try (Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(historySql)) {
                    while (rs.next()) {
                        count++;
                        System.out.println("------------------------------------------------------------");
                        System.out.println("#" + count + "  Time       : " + rs.getString(1));
                        System.out.println("    Type       : " + rs.getString(2));
                        System.out.println("    Status     : " + rs.getString(3));
                        System.out.println("    Warehouse  : " + rs.getString(4));
                        System.out.println("    Database   : " + rs.getString(5));
                        System.out.println("    Schema     : " + rs.getString(6));
                        System.out.println("    Elapsed ms : " + rs.getString(7));
                        System.out.println("    Query ID   : " + rs.getString(8));
                        String sql = rs.getString(9);
                        if (sql != null) {
                            sql = sql.replace('\r', ' ').replace('\n', ' ').replaceAll("\\s+", " ");
                            if (sql.length() > 300) sql = sql.substring(0, 300) + " ...[truncated]";
                        }
                        System.out.println("    SQL        : " + sql);
                    }
                }
                if (count == 0) System.out.println("    No visible query history found.");
                System.out.println("------------------------------------------------------------");
                System.out.println("    Displayed records : " + count);
                System.out.println("    Note: This is NOT a complete account-wide audit.");
                System.out.println("    Note: QUERY_HISTORY is limited to recent/visible queries.");
                System.out.println();
                System.out.println("OVERALL RESULT : SUCCESS");
            }
        } catch (Exception e) {
            System.out.println("OVERALL RESULT : FAILED");
            System.out.println("Error type     : " + e.getClass().getSimpleName());
            System.out.println("Error message  : " + e.getMessage());
            System.exit(1);
        } finally {
            System.out.println("Elapsed ms     : " + (System.currentTimeMillis() - start));
            System.out.println("============================================================");
        }
    }
}

ファイルを配置

C:\Users\Administrator\Desktop>aws s3 cp s3://snowtestsflake/Shizai/RunSnowflakeAudit.bat C:\snowflake-jdbc\
download: s3://snowtestsflake/Shizai/RunSnowflakeAudit.bat to ..\..\..\snowflake-jdbc\RunSnowflakeAudit.bat

C:\Users\Administrator\Desktop>aws s3 cp s3://snowtestsflake/Shizai/SnowflakeAuditTest.java C:\snowflake-jdbc\
download: s3://snowtestsflake/Shizai/SnowflakeAuditTest.java to ..\..\..\snowflake-jdbc\SnowflakeAuditTest.java

C:\Users\Administrator\Desktop>

ディレクトリ移動

C:\Users\Administrator\Desktop>cd /d C:\snowflake-jdbc

C:\snowflake-jdbc>

実行

C:\Users\Administrator\Desktop>cd /d C:\snowflake-jdbc

C:\snowflake-jdbc>RunSnowflakeAudit.bat
Compiling SnowflakeAuditTest.java ...
Running Snowflake audit report ...
============================================================
 SNOWFLAKE JDBC QUERY HISTORY REPORT
============================================================
Scope  : Current service user, last 24 hours
Mode   : Read only (SELECT)

10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content:
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content:
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,111 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,114 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal/computeMetadata/v1/instance/service-accounts/default/email HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,141 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: PUT http://[fd00:ec2::254]/latest/api/token HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
[1] Connection          : SUCCESS
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,024 ms, timeout: 1,000 ms
10 21, 2026 8:52:21 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: GET http://[fd00:ec2::254]/latest/dynamic/instance-identity/document HTTP/1.1
    User               : SVC_SNOWFLAKE_JDBC
    Role               : ROLE_SNOWFLAKE_JDBC
    Warehouse          : SNOWTESTSFLAKE
    Database           : SNOWTESTDB
    Schema             : TEST_SCHEMA
    Snowflake time     : 2026-10-21 04:52:21.407 -0700

[2] Query history (last 24 hours, up to 100 recent queries)
------------------------------------------------------------
#1  Time       : 2026-10-21 04:52:21.987 -0700
    Type       : SELECT
    Status     : RUNNING
    Warehouse  : SNOWTESTSFLAKE
    Database   : SNOWTESTDB
    Schema     : TEST_SCHEMA
    Elapsed ms : -1792583541987
    Query ID   : 01c7e0a8-0305-055e-0005-719200102086
    SQL        : SELECT START_TIME, QUERY_TYPE, EXECUTION_STATUS, WAREHOUSE_NAME, DATABASE_NAME, SCHEMA_NAME, TOTAL_ELAPSED_TIME, QUERY_ID, QUERY_TEXT FROM TABLE(SNOWTESTDB.INFORMATION_SCHEMA.QUERY_HISTORY(END_TIME_RANGE_START => DATEADD('HOUR', -24, CURRENT_TIMESTAMP()), RESULT_LIMIT => 100)) WHERE USER_NAME = CURR ...[truncated]
------------------------------------------------------------
#2  Time       : 2026-10-21 04:52:21.407 -0700
    Type       : SELECT
    Status     : SUCCESS
    Warehouse  : SNOWTESTSFLAKE
    Database   : SNOWTESTDB
    Schema     : TEST_SCHEMA
    Elapsed ms : 142
    Query ID   : 01c7e0a8-0305-024a-0005-71920010305e
    SQL        : SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_TIMESTAMP()
------------------------------------------------------------
    Displayed records : 2
    Note: This is NOT a complete account-wide audit.
    Note: QUERY_HISTORY is limited to recent/visible queries.

OVERALL RESULT : SUCCESS
Elapsed ms     : 10369
============================================================

Report saved: C:\snowflake-jdbc\snowflake-audit.log

ログを確認

C:\snowflake-jdbc>type C:\snowflake-jdbc\snowflake-audit.log
============================================================
 SNOWFLAKE JDBC QUERY HISTORY REPORT
============================================================
Scope  : Current service user, last 24 hours
Mode   : Read only (SELECT)

10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest handleNonRetryableHttpCode
重大: Error executing request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response status line reason: Unauthorized
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:19 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content:
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.SnowflakeUtil logResponseDetails
重大: Response content:
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/instance?api-version=2021-02-01 HTTP/1.1
10 21, 2026 8:52:19 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Error response: HTTP Response code: 401, request: GET http://169.254.169.254/metadata/identity/oauth2/token?api-version=2018-02-01&resource=https://management.azure.com HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,111 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,114 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.UnknownHostException: metadata.google.internal, request: GET http://metadata.google.internal/computeMetadata/v1/instance/service-accounts/default/email HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,141 ms, timeout: 1,000 ms
10 21, 2026 8:52:20 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: PUT http://[fd00:ec2::254]/latest/api/token HTTP/1.1
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:20 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
[1] Connection          : SUCCESS
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: I/O exception (java.net.SocketException) caught when processing request to {}->http://[fd00:ec2::254]:80: Network is unreachable: connect
10 21, 2026 8:52:21 午後 net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
情報: Retrying request to {}->http://[fd00:ec2::254]:80
10 21, 2026 8:52:21 午後 net.snowflake.client.internal.jdbc.RestRequest handleElapsedTimeoutExceeded
重大: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 1,024 ms, timeout: 1,000 ms
10 21, 2026 8:52:21 午後 net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
重大:  - Returning null response. Cause: java.net.SocketException: Network is unreachable: connect, request: GET http://[fd00:ec2::254]/latest/dynamic/instance-identity/document HTTP/1.1
    User               : SVC_SNOWFLAKE_JDBC
    Role               : ROLE_SNOWFLAKE_JDBC
    Warehouse          : SNOWTESTSFLAKE
    Database           : SNOWTESTDB
    Schema             : TEST_SCHEMA
    Snowflake time     : 2026-10-21 04:52:21.407 -0700

[2] Query history (last 24 hours, up to 100 recent queries)
------------------------------------------------------------
#1  Time       : 2026-10-21 04:52:21.987 -0700
    Type       : SELECT
    Status     : RUNNING
    Warehouse  : SNOWTESTSFLAKE
    Database   : SNOWTESTDB
    Schema     : TEST_SCHEMA
    Elapsed ms : -1792583541987
    Query ID   : 01c7e0a8-0305-055e-0005-719200102086
    SQL        : SELECT START_TIME, QUERY_TYPE, EXECUTION_STATUS, WAREHOUSE_NAME, DATABASE_NAME, SCHEMA_NAME, TOTAL_ELAPSED_TIME, QUERY_ID, QUERY_TEXT FROM TABLE(SNOWTESTDB.INFORMATION_SCHEMA.QUERY_HISTORY(END_TIME_RANGE_START => DATEADD('HOUR', -24, CURRENT_TIMESTAMP()), RESULT_LIMIT => 100)) WHERE USER_NAME = CURR ...[truncated]
------------------------------------------------------------
#2  Time       : 2026-10-21 04:52:21.407 -0700
    Type       : SELECT
    Status     : SUCCESS
    Warehouse  : SNOWTESTSFLAKE
    Database   : SNOWTESTDB
    Schema     : TEST_SCHEMA
    Elapsed ms : 142
    Query ID   : 01c7e0a8-0305-024a-0005-71920010305e
    SQL        : SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_TIMESTAMP()
------------------------------------------------------------
    Displayed records : 2
    Note: This is NOT a complete account-wide audit.
    Note: QUERY_HISTORY is limited to recent/visible queries.

OVERALL RESULT : SUCCESS
Elapsed ms     : 10369
============================================================

新しい接続情報を登録

C:\Users\Administrator>snow connection add
C:\Users\Administrator\AppData\Local\pyapp\data\snowflake-cli\12766843218322477748\3.28.0\python\Lib\site-packages\snowflake\cli\api\encoding_diagnostics.py:156: UserWarning: Encoding mismatch detected. Run 'snow helpers detect-encoding' for more details.
  warnings.warn(msg)
Enter connection name: audit_ec2
Enter account: XUQYYJQ-AW77300
Enter user: SVC_SNOWFLAKE_JDBC
Enter password:
Enter role: ROLE_SNOWFLAKE_JDBC
Enter warehouse: SNOWTESTSFLAKE
Enter database: SNOWTESTDB
Enter schema: TEST_SCHEMA
Enter host: HK33186.ap-northeast-1.privatelink.snowflakecomputing.com
Enter port: 443
Enter protocol: https
Enter region: ap-northeast-1
Enter authenticator: SNOWFLAKE_JWT
Enter workload identity provider:
Enter private key file: C:\snowflake-jdbc\keys\rsa_key.p8
Enter token file path:
Enter secondary roles:
Wrote new connection audit_ec2 to C:\Users\Administrator\AppData\Local\snowflake\config.toml

C:\Users\Administrator>

確認

C:\Users\Administrator>snow connection list
C:\Users\Administrator\AppData\Local\pyapp\data\snowflake-cli\12766843218322477748\3.28.0\python\Lib\site-packages\snowflake\cli\api\encoding_diagnostics.py:156: UserWarning: Encoding mismatch detected. Run 'snow helpers detect-encoding' for more details.
  warnings.warn(msg)
+----------------------------------------------------------------------------------------------------------------------+
| connection_name  | parameters                                                                           | is_default |
|------------------+--------------------------------------------------------------------------------------+------------|
| privatelinkS3    | {'account': 'XUQYYJQ-AW77300', 'user': 'TESTOBATA2', 'password': '****', 'host':     | False      |
|                  | 'HK33186.ap-northeast-1.privatelink.snowflakecomputing.com', 'region':               |            |
|                  | 'ap-northeast-1', 'port': 443, 'protocol': 'https', 'role': 'ACCOUNTADMIN',          |            |
|                  | 'authenticator': 'username_password_mfa'}                                            |            |
| snowtestsflakePL | {'account': 'XUQYYJQ-AW77300', 'user': 'SNOWTESTSFLAKE', 'password': '****', 'host': | False      |
|                  | 'HK33186.ap-northeast-1.privatelink.snowflakecomputing.com', 'port': 443,            |            |
|                  | 'protocol': 'https', 'warehouse': 'SNOWTESTSFLAKE', 'role': 'ACCOUNTADMIN',          |            |
|                  | 'authenticator': 'USERNAME_PASSWORD_MFA'}                                            |            |
| audit_ec2        | {'account': 'XUQYYJQ-AW77300', 'user': 'SVC_SNOWFLAKE_JDBC', 'host':                 | False      |
|                  | 'HK33186.ap-northeast-1.privatelink.snowflakecomputing.com', 'region':               |            |
|                  | 'ap-northeast-1', 'port': 443, 'protocol': 'https', 'database': 'SNOWTESTDB',        |            |
|                  | 'schema': 'TEST_SCHEMA', 'warehouse': 'SNOWTESTSFLAKE', 'role':                      |            |
|                  | 'ROLE_SNOWFLAKE_JDBC', 'authenticator': 'SNOWFLAKE_JWT', 'private_key_file':         |            |
|                  | 'C:\\snowflake-jdbc\\keys\\rsa_key.p8'}                                              |            |
+----------------------------------------------------------------------------------------------------------------------+

秘密鍵のパスフレーズを設定

C:\Users\Administrator>set /p PRIVATE_KEY_PASSPHRASE=Enter private key passphrase:
Enter private key passphrase:

接続テスト

C:\Users\Administrator>snow connection test -c audit_ec2
C:\Users\Administrator\AppData\Local\pyapp\data\snowflake-cli\12766843218322477748\3.28.0\python\Lib\site-packages\snowflake\cli\api\encoding_diagnostics.py:156: UserWarning: Encoding mismatch detected. Run 'snow helpers detect-encoding' for more details.
  warnings.warn(msg)
+-----------------------------------------------------------------------------+
| key             | value                                                     |
|-----------------+-----------------------------------------------------------|
| Connection name | audit_ec2                                                 |
| Status          | OK                                                        |
| Host            | HK33186.ap-northeast-1.privatelink.snowflakecomputing.com |
| Account         | XUQYYJQ-AW77300                                           |
| User            | SVC_SNOWFLAKE_JDBC                                        |
| Role            | ROLE_SNOWFLAKE_JDBC                                       |
| Database        | SNOWTESTDB                                                |
| Warehouse       | SNOWTESTSFLAKE                                            |
+-----------------------------------------------------------------------------+

C:\Users\Administrator>snow sql -c audit_ec2 -q "SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_WAREHOUSE()"
C:\Users\Administrator\AppData\Local\pyapp\data\snowflake-cli\12766843218322477748\3.28.0\python\Lib\site-packages\snowflake\cli\api\encoding_diagnostics.py:156: UserWarning: Encoding mismatch detected. Run 'snow helpers detect-encoding' for more details.
  warnings.warn(msg)
SELECT CURRENT_USER(), CURRENT_ROLE(), CURRENT_WAREHOUSE()
+----------------------------------------------------------------+
| CURRENT_USER()     | CURRENT_ROLE()      | CURRENT_WAREHOUSE() |
|--------------------+---------------------+---------------------|
| SVC_SNOWFLAKE_JDBC | ROLE_SNOWFLAKE_JDBC | SNOWTESTSFLAKE      |
+----------------------------------------------------------------+

ログ出力

C:\Users\Administrator>snow sql -c audit_ec2 -q "SELECT START_TIME, USER_NAME, ROLE_NAME, WAREHOUSE_NAME, DATABASE_NAME, QUERY_TYPE, EXECUTION_STATUS, QUERY_TEXT, ERROR_MESSAGE FROM TABLE(SNOWTESTDB.INFORMATION_SCHEMA.QUERY_HISTORY(END_TIME_RANGE_START => DATEADD('HOUR', -24, CURRENT_TIMESTAMP()), RESULT_LIMIT => 100)) ORDER BY START_TIME DESC"
C:\Users\Administrator\AppData\Local\pyapp\data\snowflake-cli\12766843218322477748\3.28.0\python\Lib\site-packages\snowflake\cli\api\encoding_diagnostics.py:156: UserWarning: Encoding mismatch detected. Run 'snow helpers detect-encoding' for more details.
  warnings.warn(msg)
SELECT START_TIME, USER_NAME, ROLE_NAME, WAREHOUSE_NAME, DATABASE_NAME, QUERY_TYPE, EXECUTION_STATUS, QUERY_TEXT, ERROR_MESSAGE FROM TABLE(SNOWTESTDB.INFORMATION_SCHEMA.QUERY_HISTORY(END_TIME_RANGE_START => DATEADD('HOUR', -24, CURRENT_TIMESTAMP()), RESULT_LIMIT => 100)) ORDER BY START_TIME DESC
+----------------------------------------------------------------------------------------------------------------------+
|            |            |            | WAREHOUSE_ | DATABASE_NA |            | EXECUTION_ |             | ERROR_MESS |
| START_TIME | USER_NAME  | ROLE_NAME  | NAME       | ME          | QUERY_TYPE | STATUS     | QUERY_TEXT  | AGE        |
|------------+------------+------------+------------+-------------+------------+------------+-------------+------------|
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | SELECT     | RUNNING    | SELECT      | None       |
| 15:34:26.7 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | START_TIME, |            |
| 31000-07:0 |            |            |            |             |            |            | USER_NAME,  |            |
| 0          |            |            |            |             |            |            | ROLE_NAME,  |            |
|            |            |            |            |             |            |            | WAREHOUSE_N |            |
|            |            |            |            |             |            |            | AME,        |            |
|            |            |            |            |             |            |            | DATABASE_NA |            |
|            |            |            |            |             |            |            | ME,         |            |
|            |            |            |            |             |            |            | QUERY_TYPE, |            |
|            |            |            |            |             |            |            | EXECUTION_S |            |
|            |            |            |            |             |            |            | TATUS,      |            |
|            |            |            |            |             |            |            | QUERY_TEXT, |            |
|            |            |            |            |             |            |            | ERROR_MESSA |            |
|            |            |            |            |             |            |            | GE FROM     |            |
|            |            |            |            |             |            |            | TABLE(SNOWT |            |
|            |            |            |            |             |            |            | ESTDB.INFOR |            |
|            |            |            |            |             |            |            | MATION_SCHE |            |
|            |            |            |            |             |            |            | MA.QUERY_HI |            |
|            |            |            |            |             |            |            | STORY(END_T |            |
|            |            |            |            |             |            |            | IME_RANGE_S |            |
|            |            |            |            |             |            |            | TART =>     |            |
|            |            |            |            |             |            |            | DATEADD('HO |            |
|            |            |            |            |             |            |            | UR', -24,   |            |
|            |            |            |            |             |            |            | CURRENT_TIM |            |
|            |            |            |            |             |            |            | ESTAMP()),  |            |
|            |            |            |            |             |            |            | RESULT_LIMI |            |
|            |            |            |            |             |            |            | T => 100))  |            |
|            |            |            |            |             |            |            | ORDER BY    |            |
|            |            |            |            |             |            |            | START_TIME  |            |
|            |            |            |            |             |            |            | DESC        |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | SELECT     | SUCCESS    | SELECT      | None       |
| 15:33:18.3 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | CURRENT_USE |            |
| 04000-07:0 |            |            |            |             |            |            | R(),        |            |
| 0          |            |            |            |             |            |            | CURRENT_ROL |            |
|            |            |            |            |             |            |            | E(),        |            |
|            |            |            |            |             |            |            | CURRENT_WAR |            |
|            |            |            |            |             |            |            | EHOUSE()    |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | USE        | SUCCESS    | use         | None       |
| 15:32:45.9 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | warehouse   |            |
| 68000-07:0 |            |            |            |             |            |            | "SNOWTESTSF |            |
| 0          |            |            |            |             |            |            | LAKE"       |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | USE        | SUCCESS    | use schema  | None       |
| 15:32:45.7 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | "TEST_SCHEM |            |
| 25000-07:0 |            |            |            |             |            |            | A"          |            |
| 0          |            |            |            |             |            |            |             |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | USE        | SUCCESS    | use         | None       |
| 15:32:45.5 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | database    |            |
| 21000-07:0 |            |            |            |             |            |            | "SNOWTESTDB |            |
| 0          |            |            |            |             |            |            | "           |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | USE        | SUCCESS    | use role    | None       |
| 15:32:45.2 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | "ROLE_SNOWF |            |
| 63000-07:0 |            |            |            |             |            |            | LAKE_JDBC"  |            |
| 0          |            |            |            |             |            |            |             |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | SELECT     | SUCCESS    | SELECT      | None       |
| 04:52:21.9 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | START_TIME, |            |
| 87000-07:0 |            |            |            |             |            |            | QUERY_TYPE, |            |
| 0          |            |            |            |             |            |            | EXECUTION_S |            |
|            |            |            |            |             |            |            | TATUS,      |            |
|            |            |            |            |             |            |            | WAREHOUSE_N |            |
|            |            |            |            |             |            |            | AME,        |            |
|            |            |            |            |             |            |            | DATABASE_NA |            |
|            |            |            |            |             |            |            | ME,         |            |
|            |            |            |            |             |            |            | SCHEMA_NAME |            |
|            |            |            |            |             |            |            | ,           |            |
|            |            |            |            |             |            |            | TOTAL_ELAPS |            |
|            |            |            |            |             |            |            | ED_TIME,    |            |
|            |            |            |            |             |            |            | QUERY_ID,   |            |
|            |            |            |            |             |            |            | QUERY_TEXT  |            |
|            |            |            |            |             |            |            | FROM        |            |
|            |            |            |            |             |            |            | TABLE(SNOWT |            |
|            |            |            |            |             |            |            | ESTDB.INFOR |            |
|            |            |            |            |             |            |            | MATION_SCHE |            |
|            |            |            |            |             |            |            | MA.QUERY_HI |            |
|            |            |            |            |             |            |            | STORY(END_T |            |
|            |            |            |            |             |            |            | IME_RANGE_S |            |
|            |            |            |            |             |            |            | TART =>     |            |
|            |            |            |            |             |            |            | DATEADD('HO |            |
|            |            |            |            |             |            |            | UR', -24,   |            |
|            |            |            |            |             |            |            | CURRENT_TIM |            |
|            |            |            |            |             |            |            | ESTAMP()),  |            |
|            |            |            |            |             |            |            | RESULT_LIMI |            |
|            |            |            |            |             |            |            | T => 100))  |            |
|            |            |            |            |             |            |            | WHERE       |            |
|            |            |            |            |             |            |            | USER_NAME = |            |
|            |            |            |            |             |            |            | CURRENT_USE |            |
|            |            |            |            |             |            |            | R() ORDER   |            |
|            |            |            |            |             |            |            | BY          |            |
|            |            |            |            |             |            |            | START_TIME  |            |
|            |            |            |            |             |            |            | DESC        |            |
| 2026-10-21 | SVC_SNOWFL | ROLE_SNOWF | SNOWTESTSF | SNOWTESTDB  | SELECT     | SUCCESS    | SELECT      | None       |
| 04:52:21.4 | AKE_JDBC   | LAKE_JDBC  | LAKE       |             |            |            | CURRENT_USE |            |
| 07000-07:0 |            |            |            |             |            |            | R(),        |            |
| 0          |            |            |            |             |            |            | CURRENT_ROL |            |
|            |            |            |            |             |            |            | E(),        |            |
|            |            |            |            |             |            |            | CURRENT_WAR |            |
|            |            |            |            |             |            |            | EHOUSE(),   |            |
|            |            |            |            |             |            |            | CURRENT_DAT |            |
|            |            |            |            |             |            |            | ABASE(),    |            |
|            |            |            |            |             |            |            | CURRENT_SCH |            |
|            |            |            |            |             |            |            | EMA(),      |            |
|            |            |            |            |             |            |            | CURRENT_TIM |            |
|            |            |            |            |             |            |            | ESTAMP()    |            |
+----------------------------------------------------------------------------------------------------------------------+

この要領で、ACCOUNT_ADMINユーザにて、全体の監査ログを取得

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up