Search.setIndex({docnames:["_api/airflow/providers/mysql/hooks/index","_api/airflow/providers/mysql/hooks/mysql/index","_api/airflow/providers/mysql/index","_api/airflow/providers/mysql/operators/index","_api/airflow/providers/mysql/operators/mysql/index","_api/airflow/providers/mysql/transfers/index","_api/airflow/providers/mysql/transfers/presto_to_mysql/index","_api/airflow/providers/mysql/transfers/s3_to_mysql/index","_api/airflow/providers/mysql/transfers/trino_to_mysql/index","_api/airflow/providers/mysql/transfers/vertica_to_mysql/index","commits","connections/mysql","index","operators"],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/mysql/hooks/index.rst","_api/airflow/providers/mysql/hooks/mysql/index.rst","_api/airflow/providers/mysql/index.rst","_api/airflow/providers/mysql/operators/index.rst","_api/airflow/providers/mysql/operators/mysql/index.rst","_api/airflow/providers/mysql/transfers/index.rst","_api/airflow/providers/mysql/transfers/presto_to_mysql/index.rst","_api/airflow/providers/mysql/transfers/s3_to_mysql/index.rst","_api/airflow/providers/mysql/transfers/trino_to_mysql/index.rst","_api/airflow/providers/mysql/transfers/vertica_to_mysql/index.rst","commits.rst","connections/mysql.rst","index.rst","operators.rst"],objects:{"airflow.providers":{mysql:[2,0,0,"-"]},"airflow.providers.mysql":{hooks:[0,0,0,"-"],operators:[3,0,0,"-"],transfers:[5,0,0,"-"]},"airflow.providers.mysql.hooks":{mysql:[1,0,0,"-"]},"airflow.providers.mysql.hooks.mysql":{MySQLConnectionTypes:[1,1,1,""],MySqlHook:[1,2,1,""]},"airflow.providers.mysql.hooks.mysql.MySqlHook":{bulk_dump:[1,3,1,""],bulk_load:[1,3,1,""],bulk_load_custom:[1,3,1,""],conn_name_attr:[1,4,1,""],conn_type:[1,4,1,""],default_conn_name:[1,4,1,""],get_autocommit:[1,3,1,""],get_conn:[1,3,1,""],get_iam_token:[1,3,1,""],get_uri:[1,3,1,""],hook_name:[1,4,1,""],set_autocommit:[1,3,1,""],supports_autocommit:[1,4,1,""]},"airflow.providers.mysql.operators":{mysql:[4,0,0,"-"]},"airflow.providers.mysql.operators.mysql":{MySqlOperator:[4,2,1,""]},"airflow.providers.mysql.operators.mysql.MySqlOperator":{execute:[4,3,1,""],prepare_template:[4,3,1,""],template_ext:[4,4,1,""],template_fields:[4,4,1,""],template_fields_renderers:[4,4,1,""],ui_color:[4,4,1,""]},"airflow.providers.mysql.transfers":{presto_to_mysql:[6,0,0,"-"],s3_to_mysql:[7,0,0,"-"],trino_to_mysql:[8,0,0,"-"],vertica_to_mysql:[9,0,0,"-"]},"airflow.providers.mysql.transfers.presto_to_mysql":{PrestoToMySqlOperator:[6,2,1,""]},"airflow.providers.mysql.transfers.presto_to_mysql.PrestoToMySqlOperator":{execute:[6,3,1,""],template_ext:[6,4,1,""],template_fields:[6,4,1,""],template_fields_renderers:[6,4,1,""],ui_color:[6,4,1,""]},"airflow.providers.mysql.transfers.s3_to_mysql":{S3ToMySqlOperator:[7,2,1,""]},"airflow.providers.mysql.transfers.s3_to_mysql.S3ToMySqlOperator":{execute:[7,3,1,""],template_ext:[7,4,1,""],template_fields:[7,4,1,""],ui_color:[7,4,1,""]},"airflow.providers.mysql.transfers.trino_to_mysql":{TrinoToMySqlOperator:[8,2,1,""]},"airflow.providers.mysql.transfers.trino_to_mysql.TrinoToMySqlOperator":{execute:[8,3,1,""],template_ext:[8,4,1,""],template_fields:[8,4,1,""],template_fields_renderers:[8,4,1,""],ui_color:[8,4,1,""]},"airflow.providers.mysql.transfers.vertica_to_mysql":{VerticaToMySqlOperator:[9,2,1,""]},"airflow.providers.mysql.transfers.vertica_to_mysql.VerticaToMySqlOperator":{execute:[9,3,1,""],template_ext:[9,4,1,""],template_fields:[9,4,1,""],template_fields_renderers:[9,4,1,""],ui_color:[9,4,1,""]}},objnames:{"0":["py","module","Python module"],"1":["py","data","Python data"],"2":["py","class","Python class"],"3":["py","method","Python method"],"4":["py","attribute","Python attribute"]},objtypes:{"0":"py:module","1":"py:data","2":"py:class","3":"py:method","4":"py:attribute"},terms:{"00642a46d":10,"008035450":10,"01f37967c":10,"042be2e4":10,"057f3ae3a":10,"059eda05f":10,"0a0e1af80":10,"0b0e4f7a4":10,"0b2":10,"0beta1":10,"0d214575a":10,"0dbd0f420":10,"10095":10,"10097":10,"10163":10,"10205":10,"10343ec29":10,"10483":10,"10528":10,"10530":10,"10543":10,"11032":10,"11238":10,"11242":10,"11249":10,"11447":10,"11487":10,"11688":10,"11826":10,"11855":10,"12077":10,"12082":10,"12093":10,"12206":10,"12212":10,"12304":10,"12366":10,"12390":10,"12444":10,"12449":10,"12466":10,"12558":10,"12681":10,"12917":10,"12955":10,"12af6a080":10,"12c5e5d8a":10,"13060":10,"13148":10,"13314":10,"13380":10,"13717":10,"13732":10,"13767":10,"14013":10,"14082":10,"14240":[10,12],"14487":10,"14869":[10,12],"14886":10,"15130":[10,12],"15187":[10,12],"15236":10,"15391":10,"15499":10,"15534":10,"15576":10,"15667":[10,12],"16294":10,"16405":10,"16464":10,"16501":10,"16682":10,"16872":10,"16914":[10,12],"16987":[10,12],"16e712971":10,"17015":10,"17020":10,"17080":[10,12],"1d36b0303":10,"1e576f123":10,"1fba5402b":10,"2020":10,"2021":10,"2037303ee":10,"22ca":11,"22cert":11,"22kei":11,"23rc1":10,"24c8e4c2d":10,"295d66f91":10,"2a1":10,"2fclient":11,"2fserver":11,"2ftmp":11,"32971a1a2":10,"329e6a5f7":10,"3306":[1,11],"349b0811c":10,"3696c34c2":10,"375d1ca22":10,"37681bca0":10,"3fd5ef355":10,"41bf172c1":10,"4204":10,"4b031d39e":10,"4bde99f13":10,"4e8f9cc8d":10,"5220e4c38":10,"589d6dec9":10,"5907":10,"5922":10,"59eb5de78":10,"5a439e84":10,"6576":10,"6578":10,"6610":10,"6655":10,"6669":10,"6670":10,"6680":10,"6714":10,"6792":10,"6822":10,"6889a333c":10,"68d1714f2":10,"68e4c4dcb":10,"6ab00bfcf":10,"6bf9acb90":10,"6cf76d7ac":10,"71c673e42":10,"7231":10,"7248":10,"7271":10,"7286":10,"7301":10,"7338":10,"7347":10,"7412":10,"7541":10,"75f229601":10,"7802":10,"7825e8f59":10,"807ad32c":10,"82c0e5aff":10,"85a18e13d":10,"866a601b7":10,"872b1566a":10,"8807":10,"8886":10,"8891":10,"8898":10,"88bdcfa0d":10,"8984":10,"8994":10,"8c42cf1b0":10,"9026":10,"92585ca4c":10,"9320":10,"9370":10,"9404":10,"9408":10,"94fccca97":10,"9550":10,"97a429f9d":10,"9b39f2478":10,"9b428bbbd":10,"9b76b94c9":10,"9c94b72d4":10,"9cbd7de6d":10,"class":[1,4,6,7,8,9,10,11,12],"default":[1,4,11,13],"export":11,"final":10,"function":1,"import":[6,8,9,10],"int":13,"new":10,"return":1,"super":10,"switch":10,"true":[1,4,9,11],"var":11,"while":11,AWS:[1,10],Added:[10,12],Adding:10,But:1,For:[1,4,10,11,12],RCs:10,The:[1,7,11,12],Use:[10,13],Uses:1,_hook:10,_oper:10,_sensor:10,a0e08c:[6,8,9],a1d3b271:10,a9ac2b040:10,about:10,ac2f72c98:10,accord:1,add:[10,12],addit:[10,12],ae7cb4a1:10,aeea71274:10,after:[9,10],against:[6,8,9],aip:10,airflow_conn_:11,airflow_conn_mysql_default:11,all:[10,11,12],allow:[1,6,8,9],allow_local_infil:11,alreadi:13,also:[1,11,13],amazon:[10,12],amount:[6,8],ani:1,anywai:1,api:12,appli:[10,12],apply_default:[10,12],april:10,arg:[1,9,10],argument:[10,13],asc:12,attribut:4,authent:1,auto:[10,12],autocommit:[1,4,10,12],autom:10,automat:[4,12],aws_conn_id:[1,7],aws_default:[1,7],awshook:1,b2a28d159:10,b39468d28:10,b40dffa08:10,b916b7507:10,backport:10,base:[1,4,6,7,8,9],baseoper:[4,6,7,8,9],batch:10,bbc627a3d:10,bd90136aa:10,befor:[6,8,10],being:[6,7,8],better:10,bf2b48174:10,black:10,bool:[1,4,9],boto3:10,bound:12,broken:10,bucket:7,buggfix:10,build:10,bulk_dump:1,bulk_load:[1,9],bulk_load_custom:1,bunch:[10,12],c34ef853c:10,c3b8212b6:10,c7e5bce57:10,ca4238eb4:10,cach:10,call:[10,12],can:[1,4,7,11,12,13],candid:10,capabl:11,capath:11,capit:10,cbf8001d7:10,cdc20904a:10,cdec30125:10,cert:11,chang:10,changelog:10,charact:10,charset:[1,11],check:[10,11],checksum:12,choos:[1,7,11],cipher:11,cleanup:[9,10],client:[1,10,11],code:[4,10],com:[1,7],come:[6,8,9,10],command:[4,9,10,13],comment:10,commit:[4,10,12],compat:10,complet:12,compon:11,configur:1,conn:1,conn_id:11,conn_name_attr:[1,10,12],conn_typ:1,connect:[1,4,6,7,8,9,10,12],connector:[1,10,11,12],constructor:10,contain:[1,7,11],context:[4,6,7,8,9],contrib:10,control:11,core:10,correct:10,coverag:10,create_table_mysql:13,create_table_mysql_external_fil:13,credenti:[1,7],cross:10,cursor:[1,11],d02ded65:10,d0e7db402:10,d1bce91bb:10,d200:10,d202:10,d403:10,dag:[10,12,13],data:[1,6,7,8,9,11],databas:[1,4,6,8,9,11,13],dbapi:1,dbapihook:1,decor:[10,12],default_arg:10,default_conn_nam:1,defin:[4,11],delet:[6,8,9],delimit:[1,9],depend:[1,10],destin:9,detail:[1,10,11,12],dev:[1,7,10],dict:[1,4,6,7,8],dictcursor:11,dictionari:11,directli:9,discoveri:10,doc:[1,7,10,11],docstr:10,document:[10,12],dot:[6,8,9],doubl:[6,8,9],drop:13,drop_tabl:13,drop_table_mysql_task:13,due:12,dump:1,duplic:[1,7],duplicate_key_handl:1,dynam:10,each:4,eae22cec9:10,eded:4,ee7ca128a:10,eee34ee80:10,either:[1,7],empti:1,enabl:[10,11],encod:[10,11],encount:11,end:4,escap:10,establish:1,exact:12,exactli:[1,7],exampl:[1,10,11,12,13],example_dag:13,example_mysql:13,execut:[4,6,7,8,9,13],exist:12,express:10,extend:[10,12],extern:13,extra:[1,9,11,12],extra_opt:1,extract:1,f3521fb0e:10,f3e87c503:10,f4a460:7,f6bd817a3:10,fals:[4,9],fdd9b6f65:10,featur:10,field:[1,10,11,12],file:[1,4,7,9,10,12,13],first:[10,12],fix:10,flag:9,flynt:10,folder:13,follow:[11,13],footprint:[10,12],form:10,formmatt:10,forth:13,fresh:10,from:[1,6,7,8,9,10,12],further:1,gener:10,get:1,get_autocommit:1,get_conn:1,get_iam_token:1,get_uri:1,given:13,grammar:10,guid:[4,10,12],handl:[1,7],happen:[1,7],has:12,hash:10,have:12,high:10,hook:[2,10,12],hook_nam:1,host:[11,13],hostnam:13,how:[1,4,7],howto:10,html:[1,7],http:[1,7],iam:1,idempot:[6,8,9],ignor:[1,7],implement:10,improv:10,includ:10,infil:[9,11],inform:[4,10],initi:12,input:13,instal:10,instanc:13,instead:11,integr:10,interact:1,introduc:10,issu:9,iter:4,json:[4,11],juli:10,june:10,kei:[1,7,11],kwarg:[1,4,6,7,8,9],last:10,latest:10,least:12,leav:1,let:1,level:[10,13],librari:[1,10],link:10,list:[4,10,12],load:[1,6,7,8,9,11],local:[1,9,11],local_infil:[9,11],login:[11,13],logo:10,look:4,lower:[10,12],magic:10,make:10,manual:12,map:4,markdown:10,match:[10,11],memori:[6,8,10,12],method:1,might:[11,12],migrat:12,miscellan:10,miss:10,model:[4,6,7,8,9],modul:10,month:10,more:[1,4,10],move:[6,8,9,10],must:13,my_aws_conn:1,mysql_conn_id:[1,4,6,7,8,9,13],mysql_default:[1,4,6,7,8,9],mysql_duplicate_key_handl:7,mysql_extra_opt:7,mysql_postoper:9,mysql_preoper:[6,8,9],mysql_tabl:[6,7,8,9],mysql_task:13,mysql_us:11,mysqlclient:[1,11,12],mysqlconnectiontyp:1,mysqldb:[1,11],mysqlhook:[1,10],mysqloper:4,name:[1,4,10,11],need:12,next:10,none:[1,4,6,7,8,9],notat:[6,8,9,11],note:[1,6,8,10,11],now:[6,8],number:10,object:1,octob:10,one:[4,11],onli:12,onto:13,oper:[2,6,7,8,10,12],option:[1,4,6,7,8,9,10,11],order:12,otherwis:12,our:10,out:10,over:13,overrid:1,overwrit:4,page:10,param:10,paramet:[1,4,6,7,8,9,10,11,12,13],pars:[4,10,12],pass:[11,13],password:[1,11,13],path:7,pattern:10,pem:11,per:10,permit:11,pip:10,place:[6,8,9],point:10,port:[1,13],pre:10,prepar:10,prepare_templ:4,presto:[6,12],presto_conn_id:6,presto_default:6,presto_to_mysql:[2,5],prestotomysqloper:6,prior:[6,8,9],prioriti:13,product:9,project:10,properti:1,provid:[11,13],push:[6,8],pydocstyl:10,pylint:10,pypi:[10,12],python:[1,10,11,12],pyupgrad:10,queri:[4,6,8,9],rather:1,rc2:10,rc3:10,readm:[10,12],receiv:4,recogn:4,ref:10,refactor:10,refer:[1,4,6,7,8,9,10,12],refernc:10,reflect:10,refman:[1,7],regener:10,relas:10,releas:[10,12],rema:10,remain:10,remov:[10,12],renam:10,render:4,replac:[1,7],repositori:12,repres:4,requir:[1,9,11],resourc:12,respect:[10,12],retriev:1,risk:1,run:[6,8,9,12],s3_source_kei:7,s3_to_mysql:[2,5],s3tomysqloper:7,same:13,schema:[1,11,13],script:[10,13],sdist:12,secur:1,see:[10,11],self:[1,4,6,7,8,9],sensor:10,sent:7,separ:10,server:[1,11,12],set:[1,11,13],set_autocommit:1,setup:10,sha512:12,should:[1,6,7,8,10,11],side:1,signatur:[10,12],simplifi:10,site:12,smallish:[6,8],socket:11,softwar:10,sourc:[1,4,6,7,8,9,13],specif:[4,6,8,9,11],specifi:[1,7,10,11,12],sql:[1,4,6,8,9,13],sscursor:[1,11],ssdictcursor:11,ssl:[1,11],stage:9,standard:11,statement:[4,6,8,9],str:[1,4,6,7,8,9],string:[10,11,13],structur:13,subject:10,support:[10,11],supports_autocommit:1,synchron:10,syntax:11,tab:[1,9],tabl:[1,6,7,8,9,13],table_nam:13,take:4,target:[6,8,9],task:[6,8,9],task_id:13,templat:[4,6,8,9,10,12],template_ext:[4,6,7,8,9],template_field:[4,6,7,8,9],template_fields_render:[4,6,8,9,10,12],temporari:1,test:[10,12],text:9,than:1,them:12,thi:[1,4,6,8,9,10,11,12],those:[11,12],through:[1,12],tmp:11,tmp_file:1,toc:10,token:1,tool:10,toolchain:10,top:12,transfer:[2,10],trino:[8,10,12],trino_conn_id:8,trino_default:8,trino_to_mysql:[2,5],trinotomysqloper:8,truncat:[6,8,9],twice:[6,8,9],type:[1,10,11,12],typic:[6,8,9],typo:10,ui_color:[4,6,7,8,9],unicodedecodeerror:11,union:4,unix:11,unix_socket:11,unless:1,updat:[10,12],upgrad:[10,12],upper:12,uri:11,url:11,usag:13,use:[1,4,6,8,9,10,12,13],used:[1,6,8,9,10,11,12],useful:11,user:[11,13],uses:1,using:[1,9,10,11],utf8:[1,11],utf:10,valu:4,variabl:11,verifi:12,version:[10,12],vertica:[9,12],vertica_conn_id:9,vertica_default:9,vertica_to_mysql:[2,5],verticatomysqloper:9,via:[1,12],view:13,wai:1,want:[1,12],warn:10,wave:10,were:1,what:[1,7],wheel:12,when:[7,11,12],where:[7,11,13],whether:11,which:[1,4],without:1,won:[6,8,9],word:10,work:11,wrong:10,wrongli:10,xxxx:10,xxxxxxxxxxxx:11,you:[1,7,11,12,13],your:[1,12,13]},titles:["<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.hooks</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.hooks.mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.operators</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.operators.mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.presto_to_mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.s3_to_mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.trino_to_mysql</span></code>","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">airflow.providers.mysql.transfers.vertica_to_mysql</span></code>","Package apache-airflow-providers-mysql","MySQL Connection","<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-mysql</span></code>","MySqlOperator"],titleterms:{"break":12,Using:13,airflow:[0,1,2,3,4,5,6,7,8,9,10,12,13],apach:[10,12],bug:12,chang:12,changelog:12,configur:11,connect:[11,13],content:[1,4,6,7,8,9,12],cross:12,depend:12,download:12,featur:12,fix:12,hook:[0,1],instal:12,metadata:13,modul:[1,4,6,7,8,9],mysql:[0,1,2,3,4,5,6,7,8,9,10,11,12,13],mysqloper:13,offici:12,oper:[3,4,13],packag:[10,12],pip:12,presto_to_mysql:6,provid:[0,1,2,3,4,5,6,7,8,9,10,12],requir:12,s3_to_mysql:7,submodul:[0,3,5],subpackag:2,transfer:[5,6,7,8,9],trino_to_mysql:8,vertica_to_mysql:9}})