# Parameter Validation Failure - MySQL to Snowflake

**URL:** <https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031>\
**Category:** Maia\
**Created:** [November 21, 2022, 8:57pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031 "2022-11-21T20:57:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ankit.h.joshi](https://avatars.discourse-cdn.com/v4/letter/a/839c29/32.png) [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)\
**Post date:** [November 21, 2022, 8:57pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/1 "2022-11-21T20:57:28Z")

</div>

Trying to move data from MySQL to the schema on Snowflake via MDL but getting a bellow error message

&nbsp;

#30 [Get Source Metadata] - Parameter Validation Failure:

Table - Failed to get tables. Communications link failure

&nbsp;

The last packet successfully received from the server was 40 milliseconds ago. The last packet sent successfully to the server was 27 milliseconds ago.

&nbsp;

**Note:**

\* The DB is available - Can connect it via other tools with no issue

---

<div class="post-metadata">

**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\
**Post date:** [December 6, 2022, 1:54pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/2 "2022-12-06T13:54:36Z")

</div>

Hi there [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)​ and thanks for your patience.

This could be related to the TLS version used by the MySQL instance. I do have a potential workaround you could use, however please note that these need to be considered from a security point of view as part of the advanced property will disable the SSL entirely and is not available for MySQL versions less than 8.0.8. For the workaround, try adding the advanced property of **UseSSL=false** (which will disable SSL entirely) or **enabledTLSProtocols=TLSv1.2** (or above, only available for MySQL versions after 8.0.8)

Let me know if that helps at all.

Many thanks,

Claire

---

<div class="post-metadata">

**Author:** ![ankit.h.joshi](https://avatars.discourse-cdn.com/v4/letter/a/839c29/32.png) [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)\
**Post date:** [December 30, 2022, 6:47pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/3 "2022-12-30T18:47:14Z")

</div>

[@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)​ : I dont see the option on MDL - this one is available in METL. I am trying to load the data in mysql via MDL into Snowflake. The pipeline is able to connect successfully and read the schema and tables within but when trying to sync I get the error message as mentioned in initial post

---

<div class="post-metadata">

**Author:** ![ankit.h.joshi](https://avatars.discourse-cdn.com/v4/letter/a/839c29/32.png) [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)\
**Post date:** [January 6, 2023, 11:30pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/4 "2023-01-06T23:30:56Z")

</div>

Thanks [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)​ : I was able to progress with Advance option setting as mentioned in the screenshot

---

<div class="post-metadata">

**Author:** ![umer.khan](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@umer.khan](https://matillioncommunity.discourse.group/u/umer.khan)\
**Post date:** [March 26, 2024, 3:21pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/5 "2024-03-26T15:21:12Z")

</div>

We are using RDS Query to fetch data from mysql , I don't see any advance option where I can enable or disable TLS?

---

<div class="post-metadata">

**Author:** ![ankit.h.joshi](https://avatars.discourse-cdn.com/v4/letter/a/839c29/32.png) [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)\
**Post date:** [March 26, 2024, 3:36pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/6 "2024-03-26T15:36:07Z")

</div>

Hi [@umer.khan](https://matillioncommunity.discourse.group/u/umer.khan)​ , For me the issue was connectivity which got resolved by using useSSL = FALSE in MDL as well as in METL query components - the screenshot from [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)​ helped me to resolve it. If you could further elaborate on your issue or a screenshot that might help to look into it further ?

---

<div class="post-metadata">

**Author:** ![umer.khan](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@umer.khan](https://matillioncommunity.discourse.group/u/umer.khan)\
**Post date:** [March 26, 2024, 5:03pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/7 "2024-03-26T17:03:43Z")

</div>

Thanks [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)​ for quick response.

my issue is we have RDS Query component to fetch data from AWS Replica (msyq)

The only option I think is JDBC Option, I tried that but I guess it is not being used.

 ![069Tm000003kopiIAA_0D7Tm000000lSvJKAU](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/6a743a18fad84651342e25241919f9eeb3133a22.png)

---

<div class="post-metadata">

**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\
**Post date:** [January 5, 2023, 4:04pm UTC](https://matillioncommunity.discourse.group/t/parameter-validation-failure-mysql-to-snowflake/1031/8 "2023-01-05T16:04:01Z")

</div>

Hi [@ankit.h.joshi](https://matillioncommunity.discourse.group/u/ankit.h.joshi)​

I'm so sorry for any confusion, you should be able to access it from the Advanced settings options on the Connect to MySQL page. It should look like the image here. Let me know if that helps at all!

 ![0694G00000Q3SwPQAV_0D74G000008hj4fSAA](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/7dfd8a61f707c22b99e6965b7f7dc63ea28d8fa2.png)
