1.ファイル準備

#!/bin/sh

set -euo pipefail

# Initialization - load function handler

source /var/runtime/"$(echo $_HANDLER | cut -d. -f1).sh"

# Processing

while true

do

HEADERS="$(mktemp)"

# Get an event. The HTTP request will block until one is received

EVENT_DATA=$(curl -sS -LD "$HEADERS" "http://${AWS_LAMBDA_RUNTIME_API}/2018-06-01/runtime/invocation/next")

# Extract request ID by scraping response headers received above

REQUEST_ID=$(grep -Fi Lambda-Runtime-Aws-Request-Id "$HEADERS" | tr -d '[:space:]' | cut -d: -f2)

# Run the handler function from the script

RESPONSE=$($(echo "$_HANDLER" | cut -d. -f2) "$EVENT_DATA")

# Send the response

curl "http://${AWS_LAMBDA_RUNTIME_API}/2018-06-01/runtime/invocation/$REQUEST_ID/response" -d "$RESPONSE"

done

function handler () {

EVENT_DATA=$1

echo "$EVENT_DATA" 1>&2;

# SnowSQLのバージョン確認

# --config で事前に用意した設定ファイルを指定し、書き込みエラーを防ぎます

VERSION="$(snowsql --config /etc/snowsql.conf -v)"

echo "SnowSQL Version: $VERSION" 1>&2

RESPONSE="{\"status\": \"success\", \"version\": \"$VERSION\"}"

echo $RESPONSE

}

[connections]

# WARNING WARNING WARNING WARNING WARNING WARNING

#

# The Snowflake user password is stored in plain text in this file.

# Pay special attention to the management of this file.

# Thank you.

#

# WARNING WARNING WARNING WARNING WARNING WARNING

#If a connection doesn't specify a value, it will default to these

#

#accountname = defaultaccount

#region = defaultregion

#username = defaultuser

#password = defaultpassword

#dbname = defaultdbname

#schemaname = defaultschema

#warehousename = defaultwarehouse

#rolename = defaultrolename

#proxy_host = defaultproxyhost

#proxy_port = defaultproxyport

[connections.example]

#Can be used in SnowSql as #connect example

accountname =

username =

password =

[variables]

# SnowSQL defines the variables in this section on startup.

# You can use these variables in SQL statements. For details, see

# httpsdocs.snowflake.comenuser-guidesnowsql-use.html#using-variables

# example_variable=27

[options]

# If set to false auto-completion will not occur interactive mode.

auto_completion = True

# main log file location. The file includes the log from SnowSQL main

# executable.

#tmpディレクトリに出力

log_file = /tmp

# bootstrap log file location. The file includes the log from SnowSQL bootstrap

# executable.

# log_bootstrap_file = ~.snowsqllog_bootstrap

# Default log level. Possible values CRITICAL, ERROR, WARNING, INFO

# and DEBUG.

log_level = INFO

# Timing of sql statements and table rendering.

timing = True

# Table format. Possible values psql, plain, simple, grid, fancy_grid, pipe,

# orgtbl, rst, mediawiki, html, latex, latex_booktabs, tsv.

# Recommended psql, fancy_grid and grid.

output_format = psql

# Keybindings Possible values emacs, vi.

# Emacs mode Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL.

# When Vi mode is enabled you can use modal editing features offered by Vi in the REPL.

key_bindings = emacs

# OCSP Fail Open Mode.

# The only OCSP scenario which will lead to connection failure would be OCSP response with a

# revoked status. Any other errors or in the OCSP module will not raise an error.

# ocsp_fail_open = True

# Enable temporary credential file for Linux users

# For Linux users, since there are no OS-key-store, an unsecure temporary credential for SSO can be enabled by this option. The default value for this option is False.

# client_store_temporary_credential = True

# Select statement split method (default is to use the sql_split method in snowsql, which does not support 'sql_delimiter')

# sql_split = snowflake.connector.util_text # to use connector's statement_split which has legacy support to 'sql_delimiter'.

# Force the result data to be decoded in utf-8. By default the value is set to false for compatibility with legacy data. It is recommended to set the value to true.

# json_result_force_utf8_decoding = False

2.Dockerfile作成

# 1. ベースイメージの指定

FROM public.ecr.aws/lambda/provided:latest

# 2. snowsqlのインストール

RUN dnf install -y wget

RUN wget https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/1.4/linux_x86_64/snowflake-snowsql-1.4.4-1.x86_64.rpm \

&& rpm -i ./snowflake-snowsql-1.4.4-1.x86_64.rpm \

&& rm ./snowflake-snowsql-1.4.4-1.x86_64.rpm

# 3. ファイルの配置

COPY bootstrap function.sh /var/runtime/

COPY snowsql.conf /etc/

# 4. 実行権限の付与

RUN chmod +x /var/runtime/bootstrap /var/runtime/function.sh

# 5. エントリポイントの設定

CMD [ "function.handler" ]

3.ECRへイメージをプッシュ

cloudshellの適用なディレクトリに準備したファイルをアップロードします。

リポジトリの「プッシュコマンドの表示」からイメージプッシュまでのコマンドが表示されるため、その通りに実行する。

4.Lambda関数作成

「コンテナイメージ」を選択し、先ほどプッシュしたイメージを指定します。

まとめ