feat: add docs for readonly application intent in mssql + database pinning (windmill-labs#593)

hugocasa · web-flow · commit 72b68c0573c4 · 2024-04-23T12:11:11.000+02:00
diff --git a/docs/getting_started/0_scripts_quickstart/5_sql_quickstart/index.mdx b/docs/getting_started/0_scripts_quickstart/5_sql_quickstart/index.mdx
@@ -48,6 +48,12 @@ You can find a list of all the officially supported Resource Types on
 
 :::
 
+:::tip
+
+You can pin a resource to an SQL query by adding a `-- database resource_path` line to your script. The query will automatically use the resource without having to specify it in the autogenerated user interface.
+
+:::
+
 ### PostgreSQL
 
 To be able to connect to a [PostgreSQL](https://www.postgresql.org/) instance ([Supabase](../../../integrations/supabase.md), [Neon.tech](../../../integrations/neon.md), etc.), we'll need to define a Resource with the `PostgreSQL` Resource Type first.
@@ -137,6 +143,10 @@ Fill out the form with the information of your MySQL instance and "Test connecti
 | dbname   | string | Database name   |         | true     | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
 | password | string | User's password |         | true     | Created in MS SQL (e.g., via SQL Server Management Studio) or provided by your hosting |
 
+
+To specify the application intent for read-only requests, add `-- ApplicationIntent=ReadOnly` to the script.
+
+
 ### BigQuery
 
 To be able to connect to a [BigQuery](https://cloud.google.com/bigquery) instance, we'll need to define a Resource with the `BigQuery` Resource Type first.
