Hello there! I see an AWS ECS Agent and a GCP Vertex agent but, in my use case, a GCP Cloud Run agent would be the perfect fit. Is there such a thing or do you have plans for it in a near future?

Hi, I'm trying to connect to a MySQL database and am receiving an error that there is no MySQL model. The

mysqlclient

Anaconda package won't run on my version of Python 3.8.8 but when I created a second conda environment on 3.7 I was told that it had a compatibility error with Prefect. Are there alternative ways to connect to a MySQL db using secrets & SSL args?. The specific error is:

Error during execution of task: ModuleNotFoundError("No module named 'MySQLdb'")

Quick graphql API question. I have multiple projects, which may have flows with names in common. I'd like to be able to query for a flow by name, with the project name as a query parameter.

Hi, I'm using docker image pushed on the container registry as storage. I have a lot of custom dependency py files needed to run my flow. The directory looks something like this (image below) . And my Dockerfile content is

# specify a base image

FROM python:3.8-slim

# copy all folder contents to the image

COPY . .

# install all dependencies

RUN apt-get update && apt-get -y install libpq-dev gcc && pip install psycopg2

RUN pip install -r requirements.txt

My understanding is

COPY . .

should copy all the files required to run the flow into the image. But I'm getting an error saying no module found (image attached). Also Here's my STORAGE and RUN_CONFIG

STORAGE = Docker(registry_url='<http://aws_id.dkr.ecr.region.amazonaws.com/|aws_id.dkr.ecr.region.amazonaws.com/>',

                 

image_name='name',

                 

image_tag='tag',

                 

dockerfile='Dockerfile')

RUN_CONFIG = ECSRun(run_task_kwargs={'cluster': 'cluster-name'},

                   

execution_role_arn='arn:aws:iam::aws_id:role/role',

                   

labels=['dev-modelling', 'flow-test'])

Am I missing something?? Really appreciate the help. Thanks in advance!!

Hi everyone: in Orion would it be possible to call a task from within a task?

Hi everyone: We are having an issue on running a mocked flow. We have a flow and for testing the flow, we are mocking a few tasks on the flow and creating a new test flow. The test flow is mocked correctly but when running the test flow, it is using registration_settings of the original flow rather than the new test flow. Would you be able to help? @Milly gupta

Hi community, I have an imperative api question:

flow.set_dependencies(
            upstream_tasks=[A],
            task=B,
            keyword_tasks=dict(item=A)
        )

Do I need to explicitly set a Task as an

upstream_task

when I already have it as a

keyword_task

? I’ve read that one is to set state dependencies and the other is to set data dependencies. Since a data dependency is implicitly a state dependency, having task

B

as keyword_task should be enough, right?

hey all, is there a way to run only specific tasks using tags from a flow? imagine our flow splits after a specific tag, treating two different datasets

task_1 -> task_2 -> [task_a, task_b] # i.e. task_a and task_b are independent of each other but share the same dependencies

if we define tasks as such:

task_1: [a, b]
task_2: [a, b]
task_a: [a]
task_b: [b]

Is there anything like:

prefect run --tags=a

I am really asking for functionalities I was using with

kedro

here :p

Hello all, we are currently using lambda to trigger our flows. we are also currently setting up our CI for each of these flow projects. we are using the flow id to trigger our flows through lambda. but the problem is everytime we register a new version of the flow the flow id keeps changing. we noticed the flow group id remains the same. is there a way possible that we can always trigger the latest version of our flow without having to worry about changing flow id’s.

Not sure if this is the appropriate place for this question, but - is it feasible to include a service account annotation in a k8s job template for a particular flow?

Hey all, I’m looking for a way to run multiple flows with different schedules. When I try to do this and execute each flow’s

.run()

method in a loop, though, it only the first runs and seems to block before the others run. Is there a way around this?

Hey folks. Is there a way to have Prefect treat a file on disk that was created during a task’s execution as a Result, that can be persisted using S3Result (for example) without loading that file into memory / returning it from the task function? I am trying to see if my organization can use Prefect, but our core need is to run 3rd party programs that produce large output files that may not fit in memory. Thanks and I apologize if this is already in the docs.

Hello, I am currently trying to use a DaskExecutor in an ECSRun to parallelize a flow. I’m following the documentation to create a temporary cluster with a specified worker image. My flow currently looks something like this:

def fargate_cluster(n_workers=4):
    """Start a fargate cluster using the same image as the flow run"""
    return FargateCluster(n_workers=n_workers, image=prefect.context.image)

class LeoFlow(PrefectFlow):

    def generate_flow(self):
        with Flow(name=self.name, storage=S3(bucket="raptormaps-prefect-flows")) as flow:
            ...
        flow.executor = DaskExecutor(
            cluster_class=fargate_cluster,
            cluster_kwargs={"n_workers": 4}
        )
        return flow

In the dockerfile for the image that I’m specifying in the ECSRun, I have included the following line to install dask-cloudprovider:

RUN pip install dask-cloudprovider[aws]

However, when I execute the flow, I am hitting the following error:

Unexpected error: AttributeError("module 'aiobotocore' has no attribute 'get_session'",)
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/prefect/engine/runner.py", line 48, in inner
    new_state = method(self, state, *args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/prefect/engine/flow_runner.py", line 442, in get_flow_run_state
    with self.check_for_cancellation(), executor.start():
  File "/usr/local/lib/python3.6/contextlib.py", line 81, in __enter__
    return next(self.gen)
  File "/usr/local/lib/python3.6/site-packages/prefect/executors/dask.py", line 238, in start
    with self.cluster_class(**self.cluster_kwargs) as cluster:
  File "/rprefect/leo_flow.py", line 58, in fargate_cluster
    return FargateCluster(n_workers=n_workers, image=prefect.context.image)
  File "/usr/local/lib/python3.6/site-packages/dask_cloudprovider/aws/ecs.py", line 1361, in __init__
    super().__init__(fargate_scheduler=True, fargate_workers=True, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/dask_cloudprovider/aws/ecs.py", line 726, in __init__
    self.session = aiobotocore.get_session()
AttributeError: module 'aiobotocore' has no attribute 'get_session'

Is there a specific version of dask_cloudprovider that Prefect requires?

Hey all, i´ve got a problem with Prefect Local Agent, if I run my flow it calls:

Unexpected error: TypeError("write() got multiple values for argument 'self'")
Traceback (most recent call last):
  File "c:\users\tom\anaconda3\envs\part1_end_to_end_ml_model\lib\site-packages\prefect\engine\runner.py", line 48, in inner
    new_state = method(self, state, *args, **kwargs)
  File "c:\users\tom\anaconda3\envs\part1_end_to_end_ml_model\lib\site-packages\prefect\engine\task_runner.py", line 926, in get_task_run_state
    result = self.result.write(value, **formatting_kwargs)
TypeError: write() got multiple values for argument 'self'

It fails by executing this function:

def load_data_task(self):
        logger = prefect.context.get("logger")
        <http://logger.info|logger.info>(os.getcwd())
        ... do something ...
        return self.load_data()

Regarding to this issue (https://github.com/PrefectHQ/prefect/issues/3034), it fails because

write()

function also got "self" input. But i cant delete "self" input in function

load_data_task

because it has to load function

load_data

. If i run the flow on local machine without server and agent, it works.

Hi all, is there a quick way to dump Prefect logger output to a file for local storage at the very end of a flow run? Thanks!

hi, i just encountered a bug where prefect seems to have been running the same flow run twice in parallel — not the same flow in two parallel runs, but the same flow twice in the same run. a few of this flow’s tasks spin up an emr job, and all 3 jobs got triggered twice in the same run. this is the first time i’ve encountered this issue, but i suspect it might be related to the flow having been triggered through a flow of flows. the flow had failed midway (during the GCP outage this week), and so i had to restart the child flow and the parent flow of flows. it seems that this caused the flow run to restart twice in parallel. i’m not sure sharing logs will be of any value, but i’d be happy to share the flow run ids to maybe help get some insight into what happened.

Hi Team, I want to onboard my prefect project (currently using local agent + dask executor) to run on a K8s cluster, and i have the following queries : (I found this tutorial while looking through the old threads on GKE + dask in this slack channel) 1. Storage : In order to be able to access my flows from the K8s cluster - is it recommended to use a remote storage? a. which storage might be recommended - Docker or Bitbucket? b. In order to use the Docker storage - do I need to install the all the requirements of the flow in the "extra_dockerfile_commands" block ? 2. Dask Cluster : Is using an ephemeral Dask executor recommended ? while using a Dask cluster 3. K8s in cloud : The Prefect Docs on the prefect page mention about using K8s run config , but I want to know how to get it working on a GKE cluster ?

Flow question (sorry if this is the wrong place, wasn't sure where else it fit). If I set up a flow to use git with additional storage, as per https://docs.prefect.io/orchestration/flow_config/storage.html#loading-additional-files-with-git-storage, am I able to import other python files from that folder?

Anyone know how to resolve this error (s)that prevents my flow from running?

- cloudpickle: (flow built with '1.6.0', currently running with '2.0.0')\n  - prefect: (flow built with '0.15.6', currently running with '0.15.9')\n  - python: (flow built with '3.8.8', currently running with '3.7.11')")

Cloud supports Secrets in JSON format, but how do I setup a JSON secret locally setting in

config.toml

?

Hello! I was wondering how to get the flow result location inside a task? Is this possible to do?

Hi all! Is there a way of wiping (runs, logs..) history regularly? I wouldn't like to keep data older than 7 days

@here: hello guys! I am having some issue building and deploying docker images using Prefect. I am using M1 chip to build the docker image, and it fails with the following error:

failed to get destination image "xxx": image with reference xxx was found but does not match the specified platform: wanted linux/amd64, actual: linux/arm64/v8

I have build args as: build_kwargs={"buildargs": {"PYTHON_VERSION": "3.8.12"}, "platform": ["linux/amd64"]}, can anybody please help me 🙏?

Hi, We are trying to get to talk to a sales representative for Prefect Cloud. We have filled the contact form in the Prefect web, but never got a response. May anybody help me?

#prefect-community Hello, can we run the prefect server on Windows containers? I am using Docker feature on Windows server 2019 not the docker desktop on windows.

Hello again! When using server, as I use

register

, all my new or modified flows get registered fine. On the other side, some flows I've deleted are still registered on my server. Is there a way of syncing these?

Hey again, I want to run my flow on schedule, So I’m using this guide - https://docs.prefect.io/core/tutorial/05-running-on-a-schedule.html It will run every day and will get the relevant data from an API (each time for the last day). From time to time I would like to run it manually and give it parameters at the UI level (the motivation is getting data for an interval of dates and not just a single one - My DS team may ask for data of a full year). Is there any way to do both stuff with exactly the same code? Something like “if env_vars is None: run_with_sched else run_with_env_vars” Thanks

Hey, not sure if this the right place to ask, can anyone provide an idiomatic example of using Oracle DB connection across multiple tasks please? I am helping out a colleague with an ETL flow which requires multiple queries done across multiple connections, which would preferably persist throughout the flow. The initial problem we are encountering is that you cannot pass the connection object between tasks as it needs to be serialisable.

Hello guys, I try to understand how I can pass the result of one flow to another one? Ex. The first flow should generate the meta-information about the requested video. The second flow should use this information to do some business logic. How I can do it in prefectly way?

Hello Guys, I'm configuring Prefect with ECS agent. I'm using Prefect Cloud. I registered a flow and when I go to test it, it always has a pending status. I'm using AWS ECR as Storage. When I access the Dashboard to follow the flow and see the logs, I get:

Submitted for execution: Task arn:aws:ecs:us-east-2:<my-account>:task/my-fargate-cluster/1eb7b9cbd17c448ab4fcdc76e4692297

Has anyone experienced a similar problem and can you help me? Thanks!