오지'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
aws ec2에서 인바운드 ip추가해도 접속안되는 오류 해결

ip를 추가해도 접속이 안되서 알아보니 vpc의 라우팅테이블에도 추가해야 한다.
개발노트/서버 관리 2024. 5. 27. 10:05
airflow에서 sftp로 파일 여러개 다운받으려고 할때

https://sftp_multiple_files_download_operator.py/ import os from airflow.exceptions import AirflowException from airflow.models import BaseOperator # from airflow.contrib.hooks import SSHHook from airflow.providers.ssh.hooks.ssh import SSHHook from typing import Any class SFTPMultipleFilesDownloadOperator(BaseOperator): template_fields = ('local_directory', 'remote_filename_pattern', 'remote_hos..
개발노트/airflow 2024. 4. 19. 14:09
Prev 1 2 3 4 5 6 7 8 ··· 29 Next