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","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","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:{"22ca":9,"22cert":9,"22kei":9,"2fclient":9,"2fserver":9,"2ftmp":9,"3306":[1,9],"class":[1,4,6,7,8,9],"default":[1,4,9,11],"export":9,"function":1,"import":[6,8],"int":11,"return":1,"static":1,"true":[1,4,8,9],"var":9,"while":9,AWS:1,But:1,For:[1,4,9],The:[1,7,9],Use:11,Uses:1,_get_conn_config_mysql_cli:1,_get_conn_config_mysql_connector_python:1,_serialize_cel:1,a0e08c:[6,8],accord:1,after:8,against:[6,8],airflow_conn_:9,airflow_conn_mysql_default:9,all:9,allow:[1,6,8],allow_local_infil:9,alreadi:11,also:[1,9,11],amount:6,ani:1,anywai:1,api:10,arg:[1,8],argument:[1,11],authent:1,autocommit:[1,4],automat:4,aws_conn_id:[1,7],aws_default:[1,7],awshook:1,base:[1,4,6,7,8],baseoper:[4,6,7,8],befor:6,being:[6,7],bool:[1,4,8],bucket:7,bulk_dump:1,bulk_load:[1,8],bulk_load_custom:1,can:[1,4,7,9,11],capabl:9,capath:9,cell:1,cert:9,charset:[1,9],check:9,choos:[1,7,9],cipher:9,cleanup:8,client:[1,9],code:4,com:[1,7],come:[6,8],command:[4,8,11],commit:4,compon:9,configur:1,conn:1,conn_id:9,conn_name_attr:1,conn_typ:1,connect:[1,4,6,7,8,10],connector:[1,9],contain:[1,7,9],context:[4,6,7,8],control:9,convert:1,create_table_mysql:11,create_table_mysql_external_fil:11,credenti:7,cursor:[1,9],dag:[10,11],data:[1,6,7,8,9],databas:[1,4,6,8,9,11],dbapi:1,dbapihook:1,default_conn_nam:1,defin:[4,9],delet:[6,8],delimit:[1,8],depend:1,destin:8,detail:[1,9],dev:[1,7],dict:[4,6,7],dictcursor:9,dictionari:9,differ:1,directli:8,doc:[1,7,9],doe:1,dot:[6,8],doubl:[6,8],drop:11,drop_tabl:11,drop_table_mysql_task:11,dump:1,duplic:[1,7],duplicate_key_handl:1,each:4,eded:4,either:[1,7],empti:1,enabl:9,encod:9,encount:9,end:4,establish:1,exactli:[1,7],exampl:[1,9,10,11],example_dag:11,example_mysql:11,execut:[1,4,6,7,8,11],extern:11,extra:[1,8,9],extra_opt:1,extract:1,f4a460:7,fals:[4,8],field:[1,9],file:[1,4,7,8,11],flag:8,folder:11,follow:[9,11],forth:11,from:[1,6,7,8],further:1,get:1,get_autocommit:1,get_conn:1,get_iam_token:1,get_uri:1,given:11,guid:[4,10],handl:[1,7],happen:[1,7],henc:1,hook:2,hook_nam:1,host:[9,11],hostnam:11,how:[1,4,7],html:[1,7],http:[1,7],iam:1,idempot:[6,8],ignor:[1,7],infil:[8,9],inform:4,input:11,insert:1,instanc:11,instead:9,interact:1,issu:8,iter:4,json:9,kei:[1,7,9],kwarg:[1,4,6,7,8],leav:1,let:1,level:11,librari:1,list:4,liter:1,load:[1,6,7,8,9],local:[1,8,9],local_infil:[8,9],login:[9,11],look:4,map:4,match:9,memori:6,method:1,might:9,model:[4,6,7,8],more:[1,4],move:[6,8],must:11,my_aws_conn:1,mysql_conn_id:[1,4,6,7,8,11],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:11,mysql_us:9,mysqlclient:[1,9],mysqldb:[1,9],mysqlhook:1,mysqloper:4,name:[1,4,9],none:[1,4,6,7,8],notat:[6,8,9],note:[1,6,9],noth:1,now:6,object:1,one:[4,9],onto:11,oper:[2,6,7,10],option:[1,4,6,7,8,9],over:11,overrid:1,overwrit:4,paramet:[1,4,6,7,8,9,11],pass:[1,9,11],password:[1,9,11],path:7,pem:9,permit:9,place:[6,8],port:[1,11],presto:6,presto_conn_id:6,presto_default:6,presto_to_mysql:[2,5],prestotomysqloper:6,prior:[6,8],prioriti:11,product:8,provid:[9,11],push:6,python:[1,9,10],queri:[4,6,8],receiv:4,recogn:4,refer:[1,4,10],refman:[1,7],render:4,replac:[1,7],repres:4,requir:[1,8,9],resourc:10,retriev:1,risk:1,run:[6,8],s3_source_kei:7,s3_to_mysql:[2,5],s3tomysqloper:7,same:[1,11],schema:[9,11],script:11,secur:1,see:9,self:[1,4,6,7,8],sent:7,separ:1,server:[1,9],set:[1,9,11],set_autocommit:1,should:[1,6,7,9],side:1,smallish:6,socket:9,sourc:[1,4,6,7,8,11],specif:[4,6,8,9],specifi:[1,7,9],sql:[1,4,6,8,11],sscursor:[1,9],ssdictcursor:9,ssl:[1,9],stage:8,standard:9,statement:[4,6,8],str:[1,4,6,7,8],string:[9,11],structur:11,support:9,supports_autocommit:1,syntax:9,tab:[1,8],tabl:[1,6,7,8,11],table_nam:11,take:4,target:[6,8],task:[6,8],task_id:11,templat:[4,6,8],template_ext:[4,6,7,8],template_field:[4,6,7,8],temporari:1,text:8,thi:[1,4,6,8,9],those:[1,9],through:1,tmp:9,tmp_file:1,token:1,transfer:2,truncat:[6,8],twice:[6,8],type:[1,9,10],typic:[6,8],ui_color:[4,6,7,8],unicodedecodeerror:9,union:4,unix:9,unix_socket:9,unless:1,uri:9,url:9,usag:11,use:[1,4,6,8,11],used:[1,6,8,9],useful:9,user:[9,11],using:[1,8,9],utf8:[1,9],valu:4,variabl:9,vertica:8,vertica_conn_id:8,vertica_default:8,vertica_to_mysql:[2,5],verticatomysqloper:8,via:1,view:11,wai:1,want:1,were:1,what:[1,7],when:[1,7,9],where:[7,9,11],whether:9,which:[1,4],without:1,won:[6,8],work:9,xxxxxxxxxxxx:9,you:[1,7,9,11],your:[1,11]},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>","MySQL Connection","<code class=\"docutils literal notranslate\"><span class=\"pre\">apache-airflow-providers-mysql</span></code>","MySqlOperator"],titleterms:{Using:11,airflow:[0,1,2,3,4,5,6,7,8,10,11],apach:10,configur:9,connect:[9,11],content:[1,4,6,7,8,10],hook:[0,1],metadata:11,modul:[1,4,6,7,8],mysql:[0,1,2,3,4,5,6,7,8,9,10,11],mysqloper:11,oper:[3,4,11],presto_to_mysql:6,provid:[0,1,2,3,4,5,6,7,8,10],s3_to_mysql:7,submodul:[0,3,5],subpackag:2,transfer:[5,6,7,8],vertica_to_mysql:8}})