목록2024/06 (3)

오지's blog

dict를 넘길때는 double asterik

connection_args = {"user":SNOWFLAKE_IMED_DB_USER ,"private_key":pkb ,"account":SNOWFLAKE_IMED_DB_HOST ,"warehouse":'GCIMED_WH' ,"database":'GCIMED_DB' ,"schema":'DM'}with snow.connect(**connection_args) as conn:
개발노트/Python 2024. 6. 17. 10:31
DateTimeOffset.UtcNow.ToUnixTimeSeconds() python변환

import datetimefrom pytz import UTCoriginal_time = datetime.datetime(1970, 1, 1, 0, 0, 0, tzinfo=UTC).timestamp()now = datetime.datetime.now().timestamp()
개발노트/Python 2024. 6. 13. 15:13
mstr에서 Error type: Jdbc error. Jdbc operation attempted: Connect. [42601:200045: on SQLHANDLE] Private key provided is invalid or not supported: : java.security.InvalidKeyException: IOException : DER input, Integer tag error.구성 요소 처리 방법에 오류 있음: QueryEngin

JDBC;DRIVER={net.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://xxx.ap-northeast-2.aws.snowflakecomputing.com/?user=xx&password=xxx&warehouse=xxx&db=xx&schema=DM&private_key_file=/app/mstr/MicroStrategy/keys/xx.p8&private_key_pwd=xxx};CLIENT_PREFETCH_THREADS=10;fetchsize=160; 아래로 변경 JDBC;DRIVER={net.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://xxx.ap-northeast-2.aws..
개발노트/서버 관리 2024. 6. 5. 10:33
Prev 1 Next