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","installing-providers-from-sources","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","installing-providers-from-sources.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],"17116":10,"17388":10,"17682":10,"1d36b0303":10,"1e576f123":10,"1fba5402b":10,"2020":10,"2021":[10,13],"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,"406f":13,"41bf172c1":10,"4204":10,"4b031d39e":10,"4bde99f13":10,"4d3a":13,"4dae4ec9a":10,"4e8f9cc8d":10,"512":13,"5220e4c38":10,"589d6dec9":10,"5907":10,"5922":10,"59eb5de78":10,"5a439e84":10,"5c6e":13,"6576":10,"6578":10,"6610":10,"6655":10,"6669":10,"6670":10,"6674":13,"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,"76ed2a49c":10,"7802":10,"7825e8f59":10,"807ad32c":10,"82c0e5aff":10,"85a18e13d":10,"866a601b7":10,"872b1566a":10,"87f408b1e":10,"8807":10,"8886":10,"8891":10,"8898":10,"88bdcfa0d":10,"8984":10,"8994":10,"8c42cf1b0":10,"8ec4":13,"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,14],"export":11,"final":10,"function":1,"import":[6,8,9,10,12,13],"int":14,"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,13],RCs:10,The:[1,7,11,12,13],There:13,Use:[10,14],Uses:1,_hook:10,_oper:10,_sensor:10,a0e08c:[6,8,9],a1d3b271:10,a9ac2b040:10,about:[10,13],abov:13,ac2f72c98:10,accord:1,add:[10,12],addit:[10,12],ae7cb4a1:10,aeea71274:10,after:[9,10],against:[6,8,9],aip:10,airflow:13,airflow_conn_:11,airflow_conn_mysql_default:11,aka:13,all:[10,11,12],allow:[1,6,8,9],allow_local_infil:11,alreadi:[13,14],also:[1,11,13,14],amazon:[10,12],amount:[6,8],ani:[1,13],annot:10,anywai:1,apach:13,apache_airflow_providers_mysql:13,api:12,appli:[10,12],apply_default:[10,12],april:10,arg:[1,9,10],argument:[10,14],asc:[12,13],attribut:4,authent:1,auto:[10,12],autocommit:[1,4,10,12],autom:10,automat:[4,12],avail:13,aws_conn_id:[1,7],aws_default:[1,7],awshook:1,b2a28d159:10,b39468d28:10,b40dffa08:10,b916b7507:10,ba4b:13,backport:10,base:[1,4,6,7,8,9],baseoper:[4,6,7,8,9],bash:13,batch:10,bbc627a3d:10,bd90136aa:10,be75dcd39:10,befor:[6,8,10],being:[6,7,8],belong:13,below:13,better:10,bf2b48174:10,bin:13,binari:13,black:10,bool:[1,4,9],boto3:10,bound:12,broken:10,bst:13,bucket:7,buggfix:10,build:[10,13],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,14],candid:10,capabl:11,capath:11,capit:10,cbf8001d7:10,cdc20904a:10,cde15c6e4d3a8ec4ecf4ba4b6674e08ad7de406f:13,cde1:13,cdec30125:10,cert:11,certif:13,certifi:13,chang:10,changelog:10,chapter:13,charact:10,charset:[1,11],check:[10,11,13],checksum:[12,13],choos:[1,7,11,13],cipher:11,cleanup:[9,10],client:[1,10,11],code:[4,10,13],com:[1,7,13],come:[6,8,9,10],command:[4,9,10,14],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,13],context:[4,6,7,8,9],contrib:10,control:11,core:10,correct:[10,13],coverag:10,creat:13,create_table_mysql:14,create_table_mysql_external_fil:14,credenti:[1,7],cross:10,curl:13,cursor:[1,11],d02ded65:10,d0e7db402:10,d1bce91bb:10,d200:10,d202:10,d403:10,d7de:13,dag:[10,12,14],data:[1,6,7,8,9,10,11],databas:[1,4,6,8,9,11,14],dbapi:1,dbapihook:1,decor:[10,12],default_arg:10,default_conn_nam:1,defin:[4,11],delet:[6,8,9],delimit:[1,9],dep:13,depend:[1,10],describ:13,descript:10,dest:13,destin:9,detail:[1,10,11,12,13],dev:[1,7,10],dict:[1,4,6,7,8],dictcursor:11,dictionari:11,diff:13,differ:13,directli:9,directori:13,discoveri:10,distribut:13,doc:[1,7,10,11],docstr:10,document:[10,12],dot:[6,8,9],doubl:[6,8,9],down:13,download:13,drop:[13,14],drop_tabl:14,drop_table_mysql_task:14,due:12,dump:1,duplic:[1,7],duplicate_key_handl:1,dynam:10,e08a:13,each:4,eae22cec9:10,ecf4:13,echo:13,eded:4,ee7ca128a:10,eee34ee80:10,either:[1,7],empti:1,enabl:[10,11],encod:[10,11],encount:11,end:4,escap:10,essenti:13,establish:1,exact:12,exactli:[1,7],exampl:[1,10,11,12,13,14],example_dag:14,example_mysql:14,execut:[4,6,7,8,9,14],exist:12,express:10,extend:[10,12],extern:14,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,14],fingerprint:13,first:[10,12],fix:10,flag:9,flynt:10,folder:[13,14],follow:[11,13,14],footprint:[10,12],form:10,formmatt:10,forth:14,foundat:13,fresh:10,from:[1,6,7,8,9,10,12],further:1,gener:10,get:[1,13],get_autocommit:1,get_conn:1,get_iam_token:1,get_uri:1,given:14,gmail:13,good:13,gpg:13,grammar:10,guid:[4,10,12,13],handl:[1,7],happen:[1,7],has:12,hash:10,have:12,high:10,hook:[2,10,12],hook_nam:1,host:[11,14],hostnam:14,how:[1,4,7,13],howto:10,html:[1,7],http:[1,7,13],iam:1,idempot:[6,8,9],ignor:[1,7],implement:10,improv:10,includ:10,indic:13,individu:10,infil:[9,11],inform:[4,10],initi:12,input:14,instal:10,instanc:14,instead:11,instruct:13,integr:10,interact:1,introduc:10,issu:9,issuer:13,iter:4,json:[4,11],juli:10,june:10,kaxil:13,kaxilnaik:13,kei:[1,7,11,13],know:13,kwarg:[1,4,6,7,8,9],last:10,latest:10,lazili:10,least:12,leav:1,left:13,let:1,level:[10,14],librari:[1,10],link:[10,13],list:[4,10,12],load:[1,6,7,8,9,11],local:[1,9,11,13],local_infil:[9,11],login:[11,14],logo:10,look:4,lower:[10,12],made:13,magic:10,main:13,make:10,manag:[10,13],manual:12,map:4,markdown:10,match:[10,11,13],memori:[6,8,10,12],meta:10,method:1,might:[11,12],migrat:12,mirror:13,miscellan:10,miss:10,mktemp:13,model:[4,6,7,8,9],modul:10,month:10,more:[1,4,10],most:13,move:[6,8,9,10],must:14,my_aws_conn:1,mysql:13,mysql_conn_id:[1,4,6,7,8,9,14],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:14,mysql_us:11,mysqlclient:[1,11,12],mysqlconnectiontyp:1,mysqldb:[1,11],mysqlhook:[1,10],mysqloper:[4,10],naik:13,name:[1,4,10,11],need:12,next:10,none:[1,4,6,7,8,9,13],notat:[6,8,9,11],note:[1,6,8,10,11],now:[6,8],number:10,object:1,octob:10,offici:13,onc:13,one:[4,11,13],onli:12,onto:14,oper:[2,6,7,8,10,12],optimis:12,option:[1,4,6,7,8,9,10,11],order:12,org:13,origin:13,otherwis:12,our:10,out:10,over:14,overrid:1,overwrit:4,owner:13,package_nam:13,package_vers:13,page:[10,13],param:10,paramet:[1,4,6,7,8,9,10,11,12,14],pars:[4,10,12],pass:[11,14],password:[1,11,14],path:7,pattern:10,pem:11,per:10,permit:11,pgp:13,pgpk:13,pgpv:13,pip:[10,13],place:[6,8,9],pleas:13,point:10,port:[1,14],pre:10,prepar:10,prepare_templ:4,presto:[6,12],presto_conn_id:6,presto_default:6,presto_to_mysql:[2,5],prestotomysqloper:6,previou:13,primari:13,prior:[6,8,9],prioriti:14,product:9,project:10,properti:1,provid:[11,13,14],provider_download_dir:13,push:[6,8],py3:13,pydocstyl:10,pylint:10,pypi:[10,12],python:[1,10,11,12,13],pyupgrad:10,queri:[4,6,8,9],rather:1,rc2:10,rc3:10,readm:[10,12],receiv:4,recogn:4,recommend:13,ref:10,refactor:10,refer:[1,4,6,7,8,9,10,12],reflect:10,refman:[1,7],regener:10,relas:10,releas:[10,12],relev:13,remain:10,remov:[10,12,13],renam:10,render:4,replac:[1,7],repositori:12,repres:4,requir:[1,9,11],resourc:12,respect:[10,12],retriev:1,risk:1,rsa:13,run:[6,8,9,12,13],s3_source_kei:7,s3_to_mysql:[2,5],s3tomysqloper:7,same:14,sat:13,schema:[1,11,14],script:[10,13,14],sdist:[12,13],secur:1,see:[10,11],select:13,self:[1,4,6,7,8,9,13],sensor:10,sent:7,sep:13,separ:10,server:[1,11,12,13],set:[1,11,14],set_autocommit:1,setup:10,sha512:[12,13],sha:13,shasum:13,should:[1,6,7,8,10,11,13],side:1,sign:13,signatur:[10,12,13],simplifi:10,site:12,smallish:[6,8],socket:11,softwar:[10,13],sourc:[1,4,6,7,8,9,12,14],specif:[4,6,8,9,11],specifi:[1,7,10,11,12],sql:[1,4,6,8,9,10,14],sscursor:[1,11],ssdictcursor:11,ssl:[1,11],stage:9,standard:11,statement:[4,6,8,9],step:13,str:[1,4,6,7,8,9],string:[10,11,14],structur:14,subject:10,sum:13,support:[10,11],supports_autocommit:1,synchron:10,syntax:11,tab:[1,9],tabl:[1,6,7,8,9,14],table_nam:14,take:4,tar:13,target:[6,8,9],task:[6,8,9],task_id:14,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,13],test:[10,12],text:9,than:1,them:12,thi:[1,4,6,8,9,10,11,12,13],those:[11,12,13],through:[1,12],tmp:11,tmp_file:1,toc:10,token:1,tool:10,toolchain:10,top:[12,13],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],trust:13,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,unknown:13,unless:1,updat:[10,12],upgrad:[10,12],upper:12,uri:11,url:11,usag:14,use:[1,4,6,8,9,10,12,13,14],used:[1,6,8,9,10,11,12,13],useful:11,user:[11,13,14],uses:1,using:[1,9,10,11,13],utf8:[1,11],utf:10,valid:13,valu:4,variabl:11,verifi:12,version:[10,12,13],vertica:[9,12],vertica_conn_id:9,vertica_default:9,vertica_to_mysql:[2,5],verticatomysqloper:9,via:[1,12,13],view:14,wai:1,want:[1,12,13],warn:[10,13],wave:10,well:13,were:1,what:[1,7],wheel:12,when:[7,11,12],where:[7,11,14],whether:11,which:[1,4],whl:13,why:13,without:1,won:[6,8,9],word:10,work:11,worri:13,wrong:10,wrongli:10,xxxx:10,xxxxxxxxxxxx:11,you:[1,7,11,12,13,14],your:[1,12,14]},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>","Installing from sources","MySqlOperator"],titleterms:{"break":12,Using:14,airflow:[0,1,2,3,4,5,6,7,8,9,10,12,14],apach:[10,12],bug:12,chang:12,changelog:12,configur:11,connect:[11,14],content:[1,4,6,7,8,9,12],cross:12,depend:12,download:12,featur:12,fix:12,from:13,hook:[0,1],instal:[12,13],integr:13,metadata:14,misc:12,modul:[1,4,6,7,8,9],mysql:[0,1,2,3,4,5,6,7,8,9,10,11,12,14],mysqloper:14,offici:12,oper:[3,4,14],packag:[10,12,13],pip:12,presto_to_mysql:6,provid:[0,1,2,3,4,5,6,7,8,9,10,12],pypi:13,releas:13,requir:12,s3_to_mysql:7,sourc:13,submodul:[0,3,5],subpackag:2,transfer:[5,6,7,8,9],trino_to_mysql:8,verifi:13,vertica_to_mysql:9}})