Richard Hughes
09/08/2020, 7:47 PMversion_group_id
Where is the documentation for this?Jenny
09/08/2020, 7:51 PMcreate_flow_run
mutation in the Interactive API - the docs are right there in the Interactive API page of the UI. If you want to do something different, please let us know.Richard Hughes
09/08/2020, 7:52 PMJenny
09/08/2020, 7:55 PMRichard Hughes
09/08/2020, 9:27 PMprefect run cloud --version_group_id "PROD.System.SQLFileExecution" --project "PROD" --paramters SQLFileName="F:\\Shares\\System\\Script.sql"
prefect run cloud --version_group_id "PROD.System.SQLFileExecution" --project "PROD" --parameters-string {"SQLFileName": "F:\\Shares\\System\\Script.sql"}
does this work for -ps
?Jenny
09/08/2020, 10:13 PMRichard Hughes
09/10/2020, 10:41 PMprefect run cloud
. I've tried both --parameter-string
and --parameter-file
I am using powershell console in my case, I am not sure if this is causing the issue. Example:
@{SQLFileName="F:\Shares\Snowflake\System\AccessControl.sql"} | ConvertTo-Json -compress > .\parameters.json
Get-Content .\parameters.json
prefect auth login -t $env:prefect_token
prefect run cloud --name "System.SQLFileExecution" --project "PROD" --parameters-file parameters.json
Traceback (most recent call last):
File "c:\python37\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "c:\python37\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "C:\Python37\Scripts\prefect.exe\__main__.py", line 7, in <module>
File "c:\python37\lib\site-packages\click\core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "c:\python37\lib\site-packages\click\core.py", line 782, in main
rv = self.invoke(ctx)
File "c:\python37\lib\site-packages\click\core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "c:\python37\lib\site-packages\click\core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "c:\python37\lib\site-packages\click\core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "c:\python37\lib\site-packages\click\core.py", line 610, in invoke
return callback(*args, **kwargs)
File "c:\python37\lib\site-packages\prefect\cli\run.py", line 217, in cloud
no_url=no_url,
File "c:\python37\lib\site-packages\prefect\cli\run.py", line 369, in _run_flow
file_params = json.load(params_file)
File "c:\python37\lib\json\__init__.py", line 296, in load
parse_constant=parse_constant, object_pairs_hook=object_pairs_hook, **kw)
File "c:\python37\lib\json\__init__.py", line 348, in loads
return _default_decoder.decode(s)
File "c:\python37\lib\json\decoder.py", line 337, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "c:\python37\lib\json\decoder.py", line 355, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
Jenny
09/10/2020, 11:07 PMRichard Hughes
09/10/2020, 11:17 PMJenny
09/10/2020, 11:19 PMRichard Hughes
09/10/2020, 11:24 PMprefect run cloud --name "System.SQLFileExecution" --project "PROD" --parameters-string '{\"SQLFileName\":\"F:\\Shares\\System\\Script.sql\"}'
, now my fingers are crossed again this will run in azure devops w/ remote powershell cmdletJenny
09/10/2020, 11:26 PMRichard Hughes
09/11/2020, 12:35 AM