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","connections/snowflake","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","connections/snowflake.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_connection_form_widgets:[1,2,1,""],get_ui_field_behaviour:[1,2,1,""],get_uri:[1,2,1,""],hook_name:[1,3,1,""],run:[1,2,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,""],template_fields:[6,3,1,""],template_fields_renderers:[6,3,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,""],template_fields_renderers:[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,"042be2e4":8,"0a0e1af80":8,"0b0e4f7a4":8,"0b2":8,"0beta1":8,"10097":8,"10163":8,"10205":8,"10280":8,"10343ec29":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,10],"12527":8,"12558":8,"12564":[8,10],"12681":8,"12917":8,"12955":8,"12af6a080":8,"12c5e5d8a":8,"13148":8,"13380":8,"13717":8,"13732":8,"13767":8,"14013":8,"14082":[8,10],"14487":[8,10],"14655":8,"14724":[8,10],"14886":8,"15130":8,"15236":8,"15408":8,"15533":[8,10],"15576":8,"15583":8,"15667":[8,10],"15817":[8,10],"15926":[8,10],"16102":[8,10],"16294":8,"16405":8,"16420":[8,10],"16455":8,"16464":8,"16e712971":8,"17af3beea":8,"1c9374d25":8,"1d36b0303":8,"1fba5402b":8,"2020":8,"2021":8,"2037303ee":8,"20f363940":8,"234d68938":8,"23rc1":8,"24c8e4c2d":8,"295d66f91":8,"297ad3088":8,"2a1":8,"32971a1a2":8,"349b0811c":8,"3696c34c2":8,"375d1ca22":8,"37681bca0":8,"3fd5ef355":8,"41bf172c1":8,"4204":8,"483068745":8,"4e8f9cc8d":8,"5220e4c38":8,"5816":8,"589d6dec9":8,"5906":8,"59eb5de78":8,"5a439e84":8,"608dd0ddf":8,"643e46ca7":8,"6469":8,"6714":8,"6755":8,"6889a333c":8,"68e4c4dcb":8,"6cf76d7ac":8,"6f956dc99":8,"7248":8,"7338":8,"7380":8,"7825e8f59":8,"7a0d41224":8,"7ca0b6f12":8,"7d24b088c":8,"807ad32c":8,"814e471d1":8,"8422":8,"8423":8,"85a18e13d":8,"85a3ce1a4":8,"8642":8,"872b1566a":8,"8807":8,"8886":8,"8891":8,"8898":8,"88bdcfa0d":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,"9b76b94c9":8,"9c94b72d4":8,"class":[1,4,6,7,8,10],"default":[1,4,6,7,8,13],"export":[1,9],"final":8,"import":[1,8],"new":8,"return":[1,4,7],"static":1,"super":8,"switch":8,"true":[1,4,6],AWS:[6,12],Added:[8,10],Adding:8,For:[1,4,6,7,8,10],One:1,RCs:[8,10],The:[1,7,9,10],Use:[8,12,13,14],_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,abil:[8,10],about:8,ac2f72c98:8,access:[7,9],account:[1,4,6,9,13],add:[1,8,10],added:7,adding:[8,10],addit:[8,12,14],adf:[1,4,6],ae7cb4a1:8,aeb93f8e5:8,aeea71274:8,after:[8,10],against:7,aip:8,airflow:12,airflow_conn_snowflake_default:9,all:[8,9,10],allow:[7,8,10,12],alreadi:[12,13],ani:[1,4,6],api:10,appli:[8,10],applic:[8,10],apply_default:[8,10],april:8,arg:[1,8],argument:[8,10,13],arrai:6,asc:10,ascii:[7,14],attribut:[7,8,10],authent:[1,4,6,7,8,13],auto:[8,10],autocommit:[1,4,6,8],autom:8,automat:[4,10],aws:9,aws_access_key_id:[1,9],aws_secret_access_kei:[1,9],b2a28d159:8,b40dffa08:8,b753c7fa6:8,backport:8,base:[1,4,6,7],baseoper:[4,6,7],batch:8,bd90136aa:8,been:[1,4,6],befor:[1,8],behaviour:1,black:8,bool:[1,4,6],broken:8,browser:[1,4,6],bug:8,buggfix:8,build:8,bunch:8,c34ef853c:8,c6be8b113:8,c7e5bce57:8,ca4238eb4:8,call:[7,8],can:[1,4,6,7,9,10,12,13,14],candid:8,capit:8,cbf8001d7:8,cd635dd7d:8,cdec30125:8,cf1109d66:8,chang:[7,8],changelog:8,channel:14,check:8,checksum:10,cleanup:8,client:1,cloud:6,code:4,column:6,columns_arrai:6,com:[1,4,6],come:8,command:[1,4,6,8,13],comment:8,commit:[4,8,10],common:8,compat:8,complet:10,compliant:[1,4,6],compon:9,conn:[1,8],conn_name_attr:1,conn_typ:1,connect:[1,4,6,7,8,10,12],connector:[9,10],constructor:8,contain:[6,7,14],context:[4,6,7],copi:6,copy_into_t:12,correct:[8,10],coverag:8,creat:4,create_table_sql_str:13,cross:8,csv:12,current:12,custom:[1,12,14],d0e7db402:8,d1bce91bb:8,d200:8,d305876be:8,d363adb61:8,d403:8,dag:[8,10,12,13,14],data:[7,12],databas:[1,4,6,7,9,13],datafram:[7,14],dataset:14,dbapi:1,dbapihook:1,dbf751112:8,decor:[8,10],default_arg:8,default_conn_nam:1,defin:[1,4,6,12],depend:[1,8],detail:[8,10],dev:8,dict:[1,4,6,8],dictionari:[9,13,14],differ:7,discoveri:8,doc:[8,10,12],docstr:8,document:[8,10],due:10,dynam:[8,10],e4bf8f349:8,each:4,east:9,ecc3a4df0:8,eded:4,ee7ca128a:8,eee34ee80:8,ef4af2135:8,either:12,enabl:[8,9],encod:9,end:4,environ:[7,9],establish:[12,14],exampl:[7,8,9,10,12,13,14],example_dag:[8,12,13,14],example_snowflak:[12,13,14],exclud:8,execut:[1,4,6,7,13,14],exist:[10,12],expos:[8,10],express:8,extern:1,externalbrows:[1,4,6],extra:[1,4,6,7,9,10,13,14],f3521fb0e:8,f6734b3b8:8,f6bd817a3:8,fals:1,fdd9b6f65:8,fetch:1,field:[1,7,8,10],field_delimit:12,file:[4,6,8,9,10,12],file_format:[6,12],filenam:13,filter:7,first:[8,10],fix:8,flynt:8,follow:[9,12,13,14],forc:12,form:[1,8],format:[6,8,12,14],formmatt:8,forth:13,four:8,fresh:8,from:[1,6,7,8,10,12],gener:8,get:[1,8],get_autocommit:1,get_conn:1,get_connect:1,get_connection_form_widget:1,get_hook:4,get_sqlalchemy_engin:1,get_ui_field_behaviour:1,get_uri:1,given:13,grammar:8,guid:[1,4,6,7,8,10],has:[1,4,6],hash:8,have:10,head:8,header:[7,8],high:8,hoc:8,hook:[2,8,9,10],hook_nam:1,host:[1,9,14],hostnam:9,how:[1,4,6,7],howto:8,http:[1,4,6],identifi:[1,4,6],idp:[1,4,6],implement:8,improv:8,includ:8,increas:8,inform:[1,4,6,7,8],initi:10,input:[1,13,14],instal:8,instanc:[4,12,13,14],instanti:1,integr:[8,9],intend:1,interact:1,intern:[1,4,6],introduc:8,iter:[1,4,7],jinja:7,jinja_env:7,job:8,json:[4,6,7,9],june:8,kei:[6,7,9],kwarg:[1,4,6,7],latest:8,least:10,level:[1,4,6,8,9],librari:7,limit:6,link:8,list:[1,4,6,8,10],load:[6,12],locat:6,login:[1,9,13],logo:8,look:[1,4,6,7],magic:8,manual:10,map:7,markdown:8,markdownlint:8,match:8,md003:8,messag:[7,14],method:1,might:10,migrat:10,miss:8,model:[4,6,7],modul:8,month:8,more:[1,4,6,7,8,12],move:8,multipl:[1,8],must:[1,6],name:[1,4,6,7,8,9,12,13],nativ:[1,4,6],need:[7,10],next:[8,10],nice:7,none:[1,4,6,7,8],note:[8,9],number:8,oath:9,oauth:9,object:1,octob:8,okta:[1,4,6],omit:[8,10],one:[6,12],onto:13,oper:[2,6,7,8,9,10],option:[1,4,6,7,8,9,14],order:[10,12],other:[1,4,6],otherwis:10,out:8,over:13,overrid:1,overwrit:[4,6],page:8,panda:7,param:1,paramet:[1,4,6,7,8,9,10,12,13,14],pass:[1,7,8,10,12,13],password:[1,9,13],path:[9,12,13],per:8,pip:8,point:8,possibl:1,post:14,pre:8,predefin:[12,14],prefix:6,prepar:[8,10],pretti:7,previous:8,prioriti:13,privat:9,private_key_fil:9,project:8,properti:8,provid:[12,13,14],publish:14,pydocstyl:8,pypi:[8,10],python:[8,9,10],queri:[1,4,7,14],query_id:[8,10],rc3:8,readm:[8,10],receiv:4,recogn:4,redund:8,ref:8,refer:[1,4,6,7,8,10,12],refernc:8,regener:8,region:[1,9,13],relas:8,relat:9,releas:[8,10],relev:[12,14],rema:8,remain:8,remov:[8,10],renam:8,render:[1,4,7],render_template_field:7,repositori:10,repres:4,requir:1,resourc:10,restor:[8,10],result:[7,14],results_df:7,results_df_nam:7,role:[1,4,6,7,9,13],rtype:4,rule:8,run:[1,4,7,10],s3_file_path:12,s3_kei:[6,12],s3_to_snowflak:[2,5],s3tosnowflak:[8,10],s3tosnowflakeoper:[1,6,8,9,10,11],same:6,saml:[1,4,6],schema:[1,4,6,7,8,9,10,12,13],script:8,sdist:10,secret:9,see:[8,12],select:14,self:[1,4,6,7],send:7,sensor:[8,9],separ:8,sequenti:1,session:[1,4,6,9],session_paramet:[1,4,6,8,9],set:[1,4,6,7,9,13],set_autocommit:1,setup:[1,8],sha512:10,should:9,signatur:[8,10],similarli:[12,14],simplifi:8,site:10,slack:[7,8,10],slack_conn_id:[7,14],slack_default:7,slack_messag:[7,14],slack_report:14,slack_token:7,snow:9,snowflak:[12,14],snowflake_conn_id:[1,4,6,7,12,13,14],snowflake_databas:13,snowflake_default:[1,4,6,7,9],snowflake_hook:8,snowflake_op_sql_list:13,snowflake_op_sql_multiple_stmt:13,snowflake_op_sql_str:13,snowflake_op_template_fil:13,snowflake_op_with_param:13,snowflake_rol:13,snowflake_sample_t:12,snowflake_schema:[12,13],snowflake_slack_messag:14,snowflake_slack_sql:14,snowflake_stag:12,snowflake_to_slack:[2,5,14],snowflake_warehous:13,snowflakehook:[1,4,8,10],snowflakeoper:[1,4,8,11,12,14],snowflaketoslackoper:[7,11],sourc:[1,4,6,7,12,13,14],specif:[6,12],specifi:[6,7,8,9,10],spell:8,spellcheck:8,sphinx:8,sql:[1,4,7,8,10,13,14],sql_insert_stat:13,sql_list:13,sql_multiple_stmt:13,sqlalchemi:[1,10],stage:[6,8,10,12],start_dat:8,statement:[1,4,7,8],stop:8,storag:6,store:12,str:[1,4,6,7,8,10],string:[1,8,9,12,13,14],structur:13,style:8,subject:8,support:[8,10],supports_autocommit:1,synchron:8,syntax:9,system:8,tabl:[6,7,12,14],tablefmt:7,tabul:7,take:[1,4,6,7],task_id:[12,13,14],templat:[4,7],template_ext:[4,7],template_field:[4,6,7,8,10],template_fields_render:[6,7,8],test:8,them:[1,10],thi:[1,4,6,7,8,9,10,12,14],those:10,through:[1,4,6],time:[1,4,6],times_rend:7,toc:8,todo:12,token:7,tool:[8,10],top:10,transfer:[2,8],type:[8,9,10,12],typo:8,ui_color:4,union:[1,7],updat:[8,10],upgrad:[8,10],upload:[8,10],uri:9,url:[9,14],usag:[8,10,12,13,14],use:[1,4,6,7,9,10,12,14],used:[1,9,12],user:[9,13],usernam:9,using:[1,4,6,7,8,9],utf:8,valu:4,variabl:[7,9],verifi:10,version:[8,10],via:10,view:[12,13,14],virtual:7,want:10,warehous:[1,4,6,7,9,13],warn:8,wave:[8,10],web:[1,4,6],webhook_token:[7,14],what:1,wheel:10,when:[7,8,9,10],where:13,widget:1,word:8,wrong:8,wrongli:8,you:[1,4,6,7,9,10],your:[1,4,6,9,10,12,13,14],your_okta_account_nam:[1,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","Snowflake Connection","<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-snowflake</span></code>","Snowflake operators","S3ToSnowflakeOperator","SnowflakeOperator","SnowflakeToSlackOperator"],titleterms:{"break":10,"default":9,IDs:9,Using:[12,13,14],airflow:[0,1,2,3,4,5,6,7,8,10,13,14],apach:[8,10],authent:9,bug:10,chang:10,changelog:10,configur:9,connect:[9,13,14],content:[1,4,6,7,10],cross:10,depend:10,download:10,featur:10,fix:10,hook:[0,1],instal:10,metadata:[13,14],modul:[1,4,6,7],offici:10,oper:[3,4,11,12,13,14],packag:[8,10],pip:10,provid:[0,1,2,3,4,5,6,7,8,10],requir:10,s3_to_snowflak:6,s3tosnowflakeoper:12,slack:14,snowflak:[0,1,2,3,4,5,6,7,8,9,10,11,13],snowflake_to_slack:7,snowflakeoper:13,snowflaketoslackoper:14,submodul:[0,3,5],subpackag:2,transfer:[5,6,7],webhook:14}})