Hi Folks! I ran into issues when I tried using ele...
# community-support
k
Hi Folks! I ran into issues when I tried using elementary github action (https://github.com/elementary-data/run-elementary-action). Here is some context: Our AWS Redshift sits inside an AWS VPC and I'm not sure if the github action is able to access the redshift since I see timeout errors. Here is the github workflow that I used:
Copy code
name: Run Elementary
on:

  # Run the action in a scheduled manner every hour.
  schedule:
    - cron: '0 0 * * *'

  # Allows you to run this workflow manually from the Actions tab.
  workflow_dispatch:

jobs:
  elementary:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout dbt project
        uses: actions/checkout@v3

      - name: Run Elementary
        uses: elementary-data/run-elementary-action@v1.8
        with:
          warehouse-type: redshift # Type of warehouse to use (bigquery, snowflake, redshift, etc.)
          profiles-yml: ${{ secrets.ELEMENTARY_PROFILES_YML }} # Content of ~/.dbt/profiles.yml, should have an `elementary` profile.
          edr-command:
            edr monitor
              --slack-token "${{ secrets.SLACK_TOKEN }}"
              --slack-channel-name "${{ secrets.SLACK_CHANNEL_NAME }}"
            &&
            edr report
              --file-path "report.html"
            &&
            edr send-report
              --slack-token "${{ secrets.SLACK_TOKEN }}"
              --slack-channel-name "${{ secrets.SLACK_CHANNEL_NAME }}"
              --aws-access-key-id "${{ secrets.AWS_ACCESS_KEY_ID }}"
              --aws-secret-access-key "${{ secrets.AWS_SECRET_ACCESS_KEY }}"
              --s3-bucket-name "some-s3-bucket"
              --update-bucket-website "true"

      - name: Upload report
        uses: actions/upload-artifact@v3
        with:
          name: report.html
          path: report.html

      - name: Upload log
        if: always()
        uses: actions/upload-artifact@v3
        with:
          name: edr.log
          path: edr.log
Am I missing something?
👀 1
e
Hey there @Kaushik Kandakatla! Thanks for reaching out. What's the error you're receiving? Are you able to query the redshift from other github actions? I'm assuming you've set up all the credentials as per the readme including the
profiles-yml
?