u/p-mndl

Pipeline refresh SQL endpoint activity not accepting variable library GUIDs

Pipeline refresh SQL endpoint activity not accepting variable library GUIDs

Basically title. I tried the new refresh sql endpoint activity together with a variable library. 1 guid for the workspace, 1 guid for the sql endpoint. Both variables are set to Guid within the variable library, but I am still getting this error when trying to use said variables within a Refresh sql endpoint activity. Is this a bug or am I doing something wrong?

https://preview.redd.it/sny6sugywawg1.png?width=608&format=png&auto=webp&s=3197f17b98ede29ecdac2752ad7837ddc91723cc

reddit.com
u/p-mndl — 1 day ago

Variable library item reference - preview status

Hey there,

anyone knows anything on the development status of item references in variable library?

I learned my lesson regarding preview items the hard way in the past, but I can't help myself, I like this feature.

  • you can hover over the item references to see what workspace it is referencing. When using guids you have to look them up to see where they point to
  • you don't have to look up guids when setting up variables, simply search for the file in the file picker
  • previously I needed 2 variables for 1 reference (workspace guid & item guid). Now I can reference both properties through the same variable

All in all a great feature and imo better than static guids in every way

Now I am wondering

  • are there known issues?
  • when will there be support for item properties like an SQL endpoint guid?
  • regarding to the docs Pipelines are not support for these variable types, but they do in fact work. When will there be official support?
  • on a scale of 1 to 10, how dumb am I for considering to use a preview feature in production?
u/p-mndl — 1 day ago