Search.setIndex({docnames:["_api/airflow/providers/snowflake/hooks/index","_api/airflow/providers/snowflake/hooks/snowflake/index","_api/airflow/providers/snowflake/index","_api/airflow/providers/snowflake/operators/index","_api/airflow/providers/snowflake/operators/snowflake/index","_api/airflow/providers/snowflake/transfers/index","_api/airflow/providers/snowflake/transfers/s3_to_snowflake/index","_api/airflow/providers/snowflake/transfers/snowflake_to_slack/index","commits","index","operators/index","operators/s3_to_snowflake","operators/snowflake","operators/snowflake_to_slack"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":3,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":2,"sphinx.domains.rst":2,"sphinx.domains.std":1,"sphinx.ext.intersphinx":1,"sphinx.ext.viewcode":1,sphinx:56},filenames:["_api/airflow/providers/snowflake/hooks/index.rst","_api/airflow/providers/snowflake/hooks/snowflake/index.rst","_api/airflow/providers/snowflake/index.rst","_api/airflow/providers/snowflake/operators/index.rst","_api/airflow/providers/snowflake/operators/snowflake/index.rst","_api/airflow/providers/snowflake/transfers/index.rst","_api/airflow/providers/snowflake/transfers/s3_to_snowflake/index.rst","_api/airflow/providers/snowflake/transfers/snowflake_to_slack/index.rst","commits.rst","index.rst","operators/index.rst","operators/s3_to_snowflake.rst","operators/snowflake.rst","operators/snowflake_to_slack.rst"],objects:{"airflow.providers":{snowflake:[2,0,0,"-"]},"airflow.providers.snowflake":{hooks:[0,0,0,"-"],operators:[3,0,0,"-"],transfers:[5,0,0,"-"]},"airflow.providers.snowflake.hooks":{snowflake:[1,0,0,"-"]},"airflow.providers.snowflake.hooks.snowflake":{SnowflakeHook:[1,1,1,""]},"airflow.providers.snowflake.hooks.snowflake.SnowflakeHook":{_get_aws_credentials:[1,2,1,""],_get_conn_params:[1,2,1,""],conn_name_attr:[1,3,1,""],conn_type:[1,3,1,""],default_conn_name:[1,3,1,""],get_autocommit:[1,2,1,""],get_conn:[1,2,1,""],get_uri:[1,2,1,""],hook_name:[1,3,1,""],set_autocommit:[1,2,1,""],supports_autocommit:[1,3,1,""]},"airflow.providers.snowflake.operators":{snowflake:[4,0,0,"-"]},"airflow.providers.snowflake.operators.snowflake":{SnowflakeOperator:[4,1,1,""]},"airflow.providers.snowflake.operators.snowflake.SnowflakeOperator":{execute:[4,2,1,""],get_hook:[4,2,1,""],template_ext:[4,3,1,""],template_fields:[4,3,1,""],ui_color:[4,3,1,""]},"airflow.providers.snowflake.transfers":{s3_to_snowflake:[6,0,0,"-"],snowflake_to_slack:[7,0,0,"-"]},"airflow.providers.snowflake.transfers.s3_to_snowflake":{S3ToSnowflakeOperator:[6,1,1,""]},"airflow.providers.snowflake.transfers.s3_to_snowflake.S3ToSnowflakeOperator":{execute:[6,2,1,""]},"airflow.providers.snowflake.transfers.snowflake_to_slack":{SnowflakeToSlackOperator:[7,1,1,""]},"airflow.providers.snowflake.transfers.snowflake_to_slack.SnowflakeToSlackOperator":{_get_query_results:[7,2,1,""],_get_slack_hook:[7,2,1,""],_get_snowflake_hook:[7,2,1,""],_render_and_send_slack_message:[7,2,1,""],execute:[7,2,1,""],render_template_fields:[7,2,1,""],template_ext:[7,3,1,""],template_fields:[7,3,1,""],times_rendered:[7,3,1,""]}},objnames:{"0":["py","module","Python module"],"1":["py","class","Python class"],"2":["py","method","Python method"],"3":["py","attribute","Python attribute"]},objtypes:{"0":"py:module","1":"py:class","2":"py:method","3":"py:attribute"},terms:{"00642a46d":8,"008035450":8,"0161b5ea2":8,"0a0e1af80":8,"0b0e4f7a4":8,"0b2":8,"0beta1":8,"10097":8,"10163":8,"10205":8,"10280":8,"10483":8,"10528":8,"10530":8,"10543":8,"10818":8,"10838":8,"11159":8,"11238":8,"11242":8,"11249":8,"11448":8,"11487":8,"11688":8,"11806":8,"11826":8,"11855":8,"11975":8,"12071":8,"12082":8,"12093":8,"12206":8,"12212":8,"12304":8,"12366":8,"12390":8,"12427":8,"12438":8,"12444":8,"12449":8,"12466":8,"12504":8,"12505":[8,9],"12527":8,"12558":8,"12564":[8,9],"12681":8,"12917":8,"12955":8,"12af6a080":8,"12c5e5d8a":8,"13148":8,"13380":8,"13717":8,"13732":8,"13767":8,"16e712971":8,"17af3beea":8,"1c9374d25":8,"1d36b0303":8,"2020":[8,9],"2021":8,"2037303ee":8,"234d68938":8,"23rc1":8,"24c8e4c2d":8,"295d66f91":8,"297ad3088":8,"2a1":8,"32971a1a2":8,"349b0811c":8,"3696c34c2":8,"375d1ca22":8,"3fd5ef355":8,"41bf172c1":8,"4204":8,"483068745":8,"4e8f9cc8d":8,"5220e4c38":8,"5816":8,"5906":8,"59eb5de78":8,"5a439e84":8,"6469":8,"6714":8,"6755":8,"6889a333c":8,"6cf76d7ac":8,"7248":8,"7338":8,"7380":8,"7825e8f59":8,"7ca0b6f12":8,"7d24b088c":8,"8422":8,"8423":8,"85a18e13d":8,"85a3ce1a4":8,"8642":8,"872b1566a":8,"8807":8,"8886":8,"8891":8,"8898":8,"8984":8,"8994":8,"8b1":8,"9023":8,"9026":8,"92585ca4c":8,"9276607b5":8,"9320":8,"9370":8,"9404":8,"9408":8,"9549274d1":8,"9550":8,"97a429f9d":8,"9985":8,"9b39f2478":8,"case":9,"class":[1,4,6,7,8,9],"default":[4,6,7,8,12],"export":1,"final":8,"import":1,"new":9,"return":[1,4,7],"super":8,"switch":8,"true":[1,4,6],AWS:[6,11],Added:8,Adding:8,For:[4,6,7,8,9],One:1,The:7,Use:[8,11,12,13],_get_aws_credenti:1,_get_conn_param:1,_get_query_result:7,_get_slack_hook:7,_get_snowflake_hook:7,_render_and_send_slack_messag:7,a546a10b1:8,a9ac2b040:8,about:8,ac2f72c98:8,access:7,account:[4,6,12],add:[8,9],added:7,addit:[11,13],adf:[4,6],ae7cb4a1:8,aeea71274:8,against:7,aip:8,airflow:11,all:[8,9],allow:[7,11],alreadi:[11,12],ani:[1,4,6],api:9,arg:[1,8],argument:[8,9,12],arrai:6,ascii:[7,13],attribut:7,authent:[4,6,7,8,12],auto:8,autocommit:[1,4,6,8],autom:8,automat:4,aws_access_key_id:1,aws_secret_access_kei:1,azur:9,b2a28d159:8,b40dffa08:8,backport:[8,9],base:[1,4,6,7],baseoper:[4,6,7],batch:8,bd90136aa:8,been:[4,6,9],black:8,blob:9,bool:[4,6],broken:8,browser:[4,6],bug:8,build:8,c34ef853c:8,c7e5bce57:8,ca4238eb4:8,call:[7,8],can:[4,6,7,9,11,12,13],candid:8,capit:8,cd635dd7d:8,cdec30125:8,cf1109d66:8,chang:[7,8],changelog:8,channel:13,check:8,choic:9,cleanup:8,cloud:6,code:4,column:6,columns_arrai:6,com:[4,6],come:8,command:[4,6,8,9,12],comment:8,commit:[4,8,9],common:[8,9],compliant:[4,6],conn:[1,8],conn_name_attr:1,conn_typ:1,connect:[1,4,6,7,8,9,11],connector:9,constructor:8,contain:[6,7,13],context:[4,6,7],copi:6,copy_into_t:11,core:9,correct:8,coverag:8,creat:4,create_table_sql_str:12,cross:8,csv:11,current:11,custom:[11,13],d0e7db402:8,d1bce91bb:8,d200:8,d305876be:8,d363adb61:8,d403:8,dag:[8,9,11,12,13],data:[7,11],databas:[4,6,7,12],datafram:[7,13],dataset:13,dbapi:1,dbapihook:1,dbf751112:8,default_arg:8,default_conn_nam:1,defin:[4,6,11],depend:[1,8],deprec:9,detail:[8,9],dev:8,dict:[1,4,6,8],dictionari:[12,13],differ:7,discoveri:8,doc:[8,11],docstr:8,document:[8,9],doe:9,downgrad:9,dynam:8,each:4,ecc3a4df0:8,eded:4,ee7ca128a:8,eee34ee80:8,ef4af2135:8,either:[9,11],enabl:8,end:4,environ:7,error:9,establish:[11,13],exampl:[7,8,9,11,12,13],example_dag:[8,11,12,13],example_snowflak:[11,12,13],execut:[4,6,7,12,13],exist:[9,11],express:8,extern:1,externalbrows:[4,6],extra:[1,4,6,7,9,12,13],f3521fb0e:8,f6734b3b8:8,f6bd817a3:8,fdd9b6f65:8,fetch:1,field:[7,8],field_delimit:11,file:[4,6,8,9,11],file_format:[6,11],filenam:12,filter:7,first:8,fix:[8,9],flynt:8,follow:[11,12,13],forc:11,form:8,format:[6,11,13],formmatt:8,forth:12,fresh:8,from:[1,6,7,8,9,11],gener:8,get:8,get_autocommit:1,get_conn:1,get_connect:1,get_hook:4,get_sqlalchemy_engin:1,get_uri:1,given:12,grammar:8,guid:[4,6,7,8,9],has:[4,6,9],hash:8,head:8,header:[7,8],high:8,hook:[2,8],hook_nam:1,host:13,how:[4,6,7],howto:8,http:[4,6],identifi:[4,6],idp:[4,6],implement:8,improv:8,includ:8,increas:8,inform:[4,6,7,8],initi:9,input:[12,13],instal:8,instanc:[4,11,12,13],integr:8,intend:1,interact:1,intern:[4,6],introduc:8,iter:[4,7],jinja:7,jinja_env:7,job:8,json:[4,6,7],kei:[6,7],kwarg:[1,4,6,7],latest:8,lead:9,legaci:9,level:[4,6,8],librari:7,limit:6,link:8,list:[4,6,8,9],load:[6,11],locat:6,login:12,logo:8,look:[4,6,7],magic:8,map:7,markdown:8,markdownlint:8,match:8,md003:8,messag:[7,13],method:1,might:9,miss:8,model:[4,6,7],modul:8,month:8,more:[4,6,7,11],move:8,multipl:8,must:6,name:[4,6,7,8,11,12],nativ:[4,6],need:[7,9],nice:7,none:[4,6,7,8],note:8,novemb:9,number:8,object:1,octob:8,okta:[4,6],one:[6,11],onto:12,oper:[2,6,7,8,9],option:[4,6,7,8,9,13],order:[9,11],other:[4,6],out:8,over:12,overrid:1,overwrit:[4,6],page:8,panda:7,param:1,paramet:[4,6,7,8,11,12,13],pass:[7,11,12],password:12,path:[11,12],per:8,pip:8,point:8,post:13,predefin:[11,13],prefix:6,prepar:8,pretti:7,prioriti:12,project:8,properti:8,provid:[11,12,13],publish:13,pydocstyl:8,pypi:[8,9],python:[8,9],queri:[4,7,13],rc3:8,readm:[8,9],receiv:4,recogn:4,redund:8,ref:8,refer:[4,6,8,9,11],refernc:8,regener:8,region:12,relas:8,releas:[8,9],relev:[11,13],rema:8,remain:8,remov:8,renam:8,render:[4,7],render_template_field:7,repositori:9,repres:4,resolv:9,resourc:9,result:[7,13],results_df:7,results_df_nam:7,role:[4,6,7,12],rtype:4,rule:8,run:[4,7],s3_file_path:11,s3_kei:[6,11],s3_to_snowflak:[2,5],s3tosnowflakeoper:[6,8,9,10],same:6,saml:[4,6],schema:[4,6,7,11,12],script:8,see:[8,11],select:13,self:[1,4,6,7],send:7,sensor:8,separ:8,session:[4,6],session_paramet:[4,6,8],set:[4,6,7,12],set_autocommit:1,setup:8,signatur:8,similarli:[11,13],simplifi:8,slack:[7,8,9],slack_conn_id:[7,13],slack_default:7,slack_messag:[7,13],slack_report:13,slack_token:7,snowflak:[11,13],snowflake_conn_id:[1,4,6,7,11,12,13],snowflake_databas:12,snowflake_default:[1,4,6,7],snowflake_hook:8,snowflake_op_sql_list:12,snowflake_op_sql_str:12,snowflake_op_template_fil:12,snowflake_op_with_param:12,snowflake_rol:12,snowflake_sample_t:11,snowflake_schema:[11,12],snowflake_slack_messag:13,snowflake_slack_sql:13,snowflake_stag:11,snowflake_to_slack:[2,5,13],snowflake_warehous:12,snowflakehook:[1,4],snowflakeoper:[4,8,10,11,13],snowflaketoslackoper:[7,10],sourc:[1,4,6,7,11,12,13],specif:[4,6,11],specifi:[6,7,8,9],spell:8,spellcheck:8,sphinx:8,sql:[4,7,12,13],sql_insert_stat:12,sql_list:12,sqlalchemi:[1,9],stage:[6,8,9,11],start_dat:8,statement:[1,4,7],stop:8,storag:[6,9],store:11,str:[4,6,7],string:[8,11,12,13],structur:12,style:8,subject:8,support:[8,9],supports_autocommit:1,system:8,tabl:[6,7,11,13],tablefmt:7,tabul:7,take:[4,6,7],task_id:[11,12,13],templat:[4,7],template_ext:[4,7],template_field:[4,7],test:8,them:9,thi:[4,6,7,8,9,11,13],those:9,through:[4,6],time:[4,6],times_rend:7,toc:8,todo:11,token:7,tool:8,top:9,transfer:[2,8],type:[8,11],typo:8,ui_color:4,union:7,updat:[8,9],upgrad:[8,9],upload:[8,9],url:13,usag:[11,12,13],use:[4,6,7,9,11,13],used:[1,11],user:12,using:[4,6,7,8],utf:8,valu:4,variabl:7,version:[8,9],via:9,view:[11,12,13],virtual:7,warehous:[4,6,7,12],warn:8,web:[4,6],webhook_token:[7,13],when:[7,9],where:12,word:8,work:9,wrong:8,wrongli:8,yet:9,you:[4,6,7,9],your:[4,6,9,11,12,13],your_okta_account_nam:[4,6]},titles:["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.hooks</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.hooks.snowflake</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.operators</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.operators.snowflake</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers.s3_to_snowflake</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.snowflake.transfers.snowflake_to_slack</span></code>","Package apache-airflow-providers-snowflake","<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-snowflake</span></code>","Snowflake operators","S3ToSnowflakeOperator","SnowflakeOperator","SnowflakeToSlackOperator"],titleterms:{Using:[11,12,13],airflow:[0,1,2,3,4,5,6,7,8,9,12,13],apach:[8,9],changelog:9,connect:[12,13],content:[1,4,6,7,9],cross:9,depend:9,featur:9,hook:[0,1],instal:9,metadata:[12,13],modul:[1,4,6,7],oper:[3,4,10,11,12,13],packag:[8,9],pip:9,provid:[0,1,2,3,4,5,6,7,8,9],requir:9,s3_to_snowflak:6,s3tosnowflakeoper:11,slack:13,snowflak:[0,1,2,3,4,5,6,7,8,9,10,12],snowflake_to_slack:7,snowflakeoper:12,snowflaketoslackoper:13,submodul:[0,3,5],subpackag:2,transfer:[5,6,7],webhook:13}})