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/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/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":{MySqlHook:[1,1,1,""]},"airflow.providers.mysql.hooks.mysql.MySqlHook":{_get_conn_config_mysql_client:[1,2,1,""],_get_conn_config_mysql_connector_python:[1,2,1,""],_serialize_cell:[1,2,1,""],bulk_dump:[1,2,1,""],bulk_load:[1,2,1,""],bulk_load_custom:[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_iam_token:[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.mysql.operators":{mysql:[4,0,0,"-"]},"airflow.providers.mysql.operators.mysql":{MySqlOperator:[4,1,1,""]},"airflow.providers.mysql.operators.mysql.MySqlOperator":{execute:[4,2,1,""],template_ext:[4,3,1,""],template_fields:[4,3,1,""],ui_color:[4,3,1,""]},"airflow.providers.mysql.transfers":{presto_to_mysql:[6,0,0,"-"],s3_to_mysql:[7,0,0,"-"],vertica_to_mysql:[8,0,0,"-"]},"airflow.providers.mysql.transfers.presto_to_mysql":{PrestoToMySqlOperator:[6,1,1,""]},"airflow.providers.mysql.transfers.presto_to_mysql.PrestoToMySqlOperator":{execute:[6,2,1,""],template_ext:[6,3,1,""],template_fields:[6,3,1,""],ui_color:[6,3,1,""]},"airflow.providers.mysql.transfers.s3_to_mysql":{S3ToMySqlOperator:[7,1,1,""]},"airflow.providers.mysql.transfers.s3_to_mysql.S3ToMySqlOperator":{execute:[7,2,1,""],template_ext:[7,3,1,""],template_fields:[7,3,1,""],ui_color:[7,3,1,""]},"airflow.providers.mysql.transfers.vertica_to_mysql":{VerticaToMySqlOperator:[8,1,1,""]},"airflow.providers.mysql.transfers.vertica_to_mysql.VerticaToMySqlOperator":{execute:[8,2,1,""],template_ext:[8,3,1,""],template_fields:[8,3,1,""],ui_color:[8,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":9,"008035450":9,"01f37967c":9,"057f3ae3a":9,"059eda05f":9,"0a0e1af80":9,"0b0e4f7a4":9,"0b2":9,"0beta1":9,"0d214575a":9,"10095":9,"10097":9,"10163":9,"10205":9,"10483":9,"10528":9,"10530":9,"10543":9,"11032":9,"11238":9,"11242":9,"11249":9,"11447":9,"11487":9,"11688":9,"11826":9,"11855":9,"12077":9,"12082":9,"12093":9,"12206":9,"12212":9,"12304":9,"12366":9,"12390":9,"12444":9,"12449":9,"12466":9,"12558":9,"12681":9,"12917":9,"12955":9,"12af6a080":9,"12c5e5d8a":9,"13060":9,"13148":9,"13314":9,"13380":9,"13717":9,"13732":9,"13767":9,"16e712971":9,"1d36b0303":9,"1e576f123":9,"2020":[9,11],"2021":9,"2037303ee":9,"22ca":10,"22cert":10,"22kei":10,"23rc1":9,"24c8e4c2d":9,"295d66f91":9,"2a1":9,"2fclient":10,"2fserver":10,"2ftmp":10,"32971a1a2":9,"329e6a5f7":9,"3306":[1,10],"349b0811c":9,"3696c34c2":9,"375d1ca22":9,"3fd5ef355":9,"41bf172c1":9,"4204":9,"4bde99f13":9,"4e8f9cc8d":9,"5220e4c38":9,"5907":9,"5922":9,"59eb5de78":9,"5a439e84":9,"6576":9,"6578":9,"6610":9,"6655":9,"6669":9,"6670":9,"6680":9,"6714":9,"6792":9,"6822":9,"6889a333c":9,"68d1714f2":9,"6bf9acb90":9,"6cf76d7ac":9,"7231":9,"7248":9,"7271":9,"7286":9,"7301":9,"7338":9,"7347":9,"7412":9,"7541":9,"75f229601":9,"7802":9,"7825e8f59":9,"82c0e5aff":9,"85a18e13d":9,"872b1566a":9,"8807":9,"8886":9,"8891":9,"8898":9,"8984":9,"8994":9,"8c42cf1b0":9,"9026":9,"92585ca4c":9,"9320":9,"9370":9,"9404":9,"9408":9,"94fccca97":9,"9550":9,"97a429f9d":9,"9b39f2478":9,"9cbd7de6d":9,"case":11,"class":[1,4,6,7,8,9,10,11],"default":[1,4,10,12],"export":10,"final":9,"function":1,"import":[6,8,9],"int":12,"new":11,"return":1,"static":1,"super":9,"switch":9,"true":[1,4,8,10],"var":10,"while":10,AWS:[1,9],Added:9,Adding:9,But:1,For:[1,4,9,10,11],The:[1,7,10,11],Use:[9,12],Uses:1,_get_conn_config_mysql_cli:1,_get_conn_config_mysql_connector_python:1,_hook:9,_oper:9,_sensor:9,_serialize_cel:1,a0e08c:[6,8],a9ac2b040:9,about:9,ac2f72c98:9,accord:1,add:[9,11],ae7cb4a1:9,aeea71274:9,after:8,against:[6,8],aip:9,airflow_conn_:10,airflow_conn_mysql_default:10,all:[9,10,11],allow:[1,6,8],allow_local_infil:10,alreadi:12,also:[1,10,12],amazon:11,amount:6,ani:1,anywai:1,api:11,arg:[1,8,9],argument:[1,9,12],authent:1,auto:9,autocommit:[1,4],autom:9,automat:4,aws_conn_id:[1,7],aws_default:[1,7],awshook:1,b2a28d159:9,b39468d28:9,b40dffa08:9,backport:[9,11],base:[1,4,6,7,8],baseoper:[4,6,7,8],batch:9,bd90136aa:9,been:11,befor:6,being:[6,7],better:9,black:9,bool:[1,4,8],boto3:9,bound:11,broken:9,bucket:7,build:9,bulk_dump:1,bulk_load:[1,8],bulk_load_custom:1,c34ef853c:9,c7e5bce57:9,ca4238eb4:9,cach:9,call:9,can:[1,4,7,10,11,12],candid:9,capabl:10,capath:10,capit:9,cdec30125:9,cell:1,cert:10,chang:9,changelog:9,charset:[1,10],check:[9,10],choic:11,choos:[1,7,10],cipher:10,cleanup:[8,9],client:[1,9,10],code:4,com:[1,7],come:[6,8,9],command:[4,8,9,11,12],comment:9,commit:[4,9,11],compat:9,compon:10,configur:1,conn:1,conn_id:10,conn_name_attr:1,conn_typ:1,connect:[1,4,6,7,8,9,11],connector:[1,10,11],constructor:9,contain:[1,7,10],context:[4,6,7,8],contrib:9,control:10,convert:1,core:9,correct:9,coverag:9,create_table_mysql:12,create_table_mysql_external_fil:12,credenti:7,cross:9,cursor:[1,10],d0e7db402:9,d1bce91bb:9,d200:9,d202:9,d403:9,dag:[9,11,12],data:[1,6,7,8,10],databas:[1,4,6,8,10,12],dbapi:1,dbapihook:1,default_conn_nam:1,defin:[4,10],delet:[6,8],delimit:[1,8],depend:[1,9],deprec:11,destin:8,detail:[1,9,10,11],dev:[1,7,9],dict:[4,6,7],dictcursor:10,dictionari:10,differ:1,directli:8,discoveri:9,doc:[1,7,9,10],docstr:9,document:[9,11],doe:[1,11],dot:[6,8],doubl:[6,8],downgrad:11,drop:12,drop_tabl:12,drop_table_mysql_task:12,dump:1,duplic:[1,7],duplicate_key_handl:1,dynam:9,each:4,eded:4,ee7ca128a:9,eee34ee80:9,either:[1,7,11],empti:1,enabl:[9,10],encod:[9,10],encount:10,end:4,error:11,establish:1,exact:11,exactli:[1,7],exampl:[1,9,10,11,12],example_dag:12,example_mysql:12,execut:[1,4,6,7,8,12],exist:11,express:9,extern:12,extra:[1,8,10,11],extra_opt:1,extract:1,f3521fb0e:9,f3e87c503:9,f4a460:7,f6bd817a3:9,fals:[4,8],fdd9b6f65:9,featur:[9,11],field:[1,9,10],file:[1,4,7,8,9,11,12],first:9,fix:9,flag:8,flynt:9,folder:12,follow:[10,12],form:9,formmatt:9,forth:12,fresh:9,from:[1,6,7,8,9,11],further:1,gener:9,get:1,get_autocommit:1,get_conn:1,get_iam_token:1,get_uri:1,given:12,grammar:9,guid:[4,9,11],handl:[1,7],happen:[1,7],has:11,hash:9,henc:1,high:9,hook:[2,9],hook_nam:1,host:[10,12],hostnam:12,how:[1,4,7],howto:9,html:[1,7],http:[1,7],iam:1,idempot:[6,8],ignor:[1,7],implement:9,improv:9,includ:9,infil:[8,10],inform:[4,9],initi:11,input:12,insert:1,instal:9,instanc:12,instead:10,integr:9,interact:1,introduc:9,issu:8,iter:4,json:10,kei:[1,7,10],kwarg:[1,4,6,7,8],last:9,latest:9,lead:11,leav:1,legaci:11,let:1,level:[9,12],librari:[1,9],link:9,list:[4,9,11],liter:1,load:[1,6,7,8,10],local:[1,8,10],local_infil:[8,10],login:[10,12],logo:9,look:4,magic:9,make:9,map:4,markdown:9,match:[9,10],memori:6,method:1,might:[10,11],miss:9,model:[4,6,7,8],modul:9,month:9,more:[1,4],move:[6,8,9],must:12,my_aws_conn:1,mysql_conn_id:[1,4,6,7,8,12],mysql_default:[1,4,6,7,8],mysql_duplicate_key_handl:7,mysql_extra_opt:7,mysql_postoper:8,mysql_preoper:[6,8],mysql_tabl:[6,7,8],mysql_task:12,mysql_us:10,mysqlclient:[1,10,11],mysqldb:[1,10],mysqlhook:[1,9],mysqloper:4,name:[1,4,9,10],need:11,none:[1,4,6,7,8],notat:[6,8,10],note:[1,6,9,10],noth:1,novemb:11,now:6,number:9,object:1,octob:9,one:[4,10],onli:11,onto:12,oper:[2,6,7,9,11],option:[1,4,6,7,8,9,10,11],order:11,out:9,over:12,overrid:1,overwrit:4,page:9,paramet:[1,4,6,7,8,9,10,12],pass:[1,10,12],password:[1,10,12],path:7,pem:10,per:9,permit:10,pip:9,place:[6,8],point:9,port:[1,12],pre:9,prepar:9,presto:[6,11],presto_conn_id:6,presto_default:6,presto_to_mysql:[2,5],prestotomysqloper:6,prior:[6,8],prioriti:12,product:8,project:9,provid:[10,12],push:6,pydocstyl:9,pylint:9,pypi:[9,11],python:[1,9,10,11],pyupgrad:9,queri:[4,6,8],rc3:9,readm:[9,11],receiv:4,recogn:4,ref:9,refactor:9,refer:[1,4,9,11],refernc:9,reflect:9,refman:[1,7],regener:9,relas:9,releas:[9,11],rema:9,remain:9,remov:9,renam:9,render:4,replac:[1,7],repositori:11,repres:4,requir:[1,8,10],resolv:11,resourc:11,retriev:1,risk:1,run:[6,8],s3_source_kei:7,s3_to_mysql:[2,5],s3tomysqloper:7,same:[1,12],schema:[10,12],script:[9,12],secur:1,see:[9,10],self:[1,4,6,7,8],sensor:9,sent:7,separ:[1,9],server:[1,10,11],set:[1,10,12],set_autocommit:1,setup:9,should:[1,6,7,9,10],side:1,signatur:9,simplifi:9,smallish:6,socket:10,softwar:9,sourc:[1,4,6,7,8,12],specif:[4,6,8,10],specifi:[1,7,9,10,11],sql:[1,4,6,8,12],sscursor:[1,10],ssdictcursor:10,ssl:[1,10],stage:8,standard:10,statement:[4,6,8],str:[1,4,6,7,8],string:[9,10,12],structur:12,subject:9,support:[9,10],supports_autocommit:1,syntax:10,tab:[1,8],tabl:[1,6,7,8,12],table_nam:12,take:4,target:[6,8],task:[6,8],task_id:12,templat:[4,6,8],template_ext:[4,6,7,8],template_field:[4,6,7,8],temporari:1,test:9,text:8,them:11,thi:[1,4,6,8,9,10,11],those:[1,10,11],through:[1,11],tmp:10,tmp_file:1,toc:9,token:1,tool:9,top:11,transfer:[2,9],truncat:[6,8],twice:[6,8],type:[1,9,10,11],typic:[6,8],typo:9,ui_color:[4,6,7,8],unicodedecodeerror:10,union:4,unix:10,unix_socket:10,unless:1,updat:[9,11],upgrad:[9,11],upper:11,uri:10,url:10,usag:12,use:[1,4,6,8,9,11,12],used:[1,6,8,9,10,11],useful:10,user:[10,12],using:[1,8,9,10],utf8:[1,10],utf:9,valu:4,variabl:10,version:[9,11],vertica:[8,11],vertica_conn_id:8,vertica_default:8,vertica_to_mysql:[2,5],verticatomysqloper:8,via:[1,11],view:12,wai:1,want:1,warn:9,were:1,what:[1,7],when:[1,7,10,11],where:[7,10,12],whether:10,which:[1,4],without:1,won:[6,8],word:9,work:[10,11],wrong:9,wrongli:9,xxxx:9,xxxxxxxxxxxx:10,yet:11,you:[1,7,10,11,12],your:[1,11,12]},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.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:{Using:12,airflow:[0,1,2,3,4,5,6,7,8,9,11,12],apach:[9,11],changelog:11,configur:10,connect:[10,12],content:[1,4,6,7,8,11],cross:11,depend:11,hook:[0,1],instal:11,metadata:12,modul:[1,4,6,7,8],mysql:[0,1,2,3,4,5,6,7,8,9,10,11,12],mysqloper:12,oper:[3,4,12],packag:[9,11],pip:11,presto_to_mysql:6,provid:[0,1,2,3,4,5,6,7,8,9,11],requir:11,s3_to_mysql:7,submodul:[0,3,5],subpackag:2,transfer:[5,6,7,8],vertica_to_mysql:8}})