BI Lineage (Looker) not detecting usage in derived tables #190
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Create Pylon Issue | |
| on: | |
| issues: | |
| types: [opened] | |
| pull_request: | |
| types: [opened] | |
| jobs: | |
| create_pylon_issue: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Check out the repository | |
| uses: actions/checkout@v2 | |
| - name: Install jq | |
| run: sudo apt-get install -y jq | |
| - name: Create Pylon Issue for GitHub Issue | |
| if: github.event_name == 'issues' | |
| run: | | |
| response=$(curl --request POST \ | |
| --url https://api.usepylon.com/issues \ | |
| --header 'Authorization: ${{ secrets.PYLON_API_KEY }}' \ | |
| --header 'Content-Type: application/json' \ | |
| --data '{ | |
| "account_id": "${{ secrets.PYLON_ACCOUNT_ID }}", | |
| "requester_id": "${{ secrets.PYLON_REQUESTER_ID }}", | |
| "priority": "medium", | |
| "title": "${{ github.event.issue.title }}", | |
| "body_html": "<html lang=en><head><title>GitHub Issue Details</title></head><body><h1>GitHub Issue Details</h1><p><strong>Repository:</strong> ${{ github.repository }}</p><p><strong>Type:</strong> Github Issue</p><p><strong>URL:</strong> <a href=${{ github.event.issue.html_url }}>${{ github.event.issue.html_url }}</a></p></body></html>" | |
| }') | |
| ticket_id=$(echo $response | jq -r '.data.id') | |
| echo "ticket_id=$ticket_id" >> $GITHUB_ENV | |
| - name: Add Pylon ticket ID to issue body | |
| if: success() | |
| run: | | |
| issue_body=$(curl -s -H "Authorization: token ${{ secrets.GITHUB_TOKEN }}" \ | |
| "https://api.github.com/repos/${{ github.repository }}/issues/${{ github.event.issue.number }}" | jq -r '.body') | |
| new_body="$issue_body<!-- pylon-ticket-id: ${{ env.ticket_id }} -->" | |
| json_body=$(jq -R -s --arg body "$new_body" '{"body": $body}' <<< "$new_body") | |
| curl -X PATCH -H "Authorization: token ${{ secrets.GITHUB_TOKEN }}" \ | |
| -H "Content-Type: application/json" \ | |
| -d "$json_body" \ | |
| "https://api.github.com/repos/${{ github.repository }}/issues/${{ github.event.issue.number }}" | |
| - name: Create Pylon Issue for Pull Request | |
| if: github.event_name == 'pull_request' | |
| run: | | |
| response=$(curl --request POST \ | |
| --url https://api.usepylon.com/issues \ | |
| --header 'Authorization: ${{ secrets.PYLON_API_KEY }}' \ | |
| --header 'Content-Type: application/json' \ | |
| --data '{ | |
| "account_id": "${{ secrets.PYLON_ACCOUNT_ID }}", | |
| "requester_id": "${{ secrets.PYLON_REQUESTER_ID }}", | |
| "priority": "high", | |
| "title": "${{ github.event.pull_request.title }}", | |
| "body_html": "<html lang=en><head><title>GitHub Pull Request Details</title></head><body><h1>GitHub Pull Request Details</h1><p><strong>Repository:</strong> ${{ github.repository }}</p><p><strong>Type:</strong> Pull Request</p><p><strong>URL:</strong> <a href=${{ github.event.pull_request.html_url }}>${{ github.event.pull_request.html_url }}</a></p></body></html>" | |
| }') | |
| ticket_id=$(echo $response | jq -r '.data.id') | |
| echo "ticket_id=$ticket_id" >> $GITHUB_ENV | |
| - name: Add Pylon ticket ID to PR body | |
| if: success() | |
| run: | | |
| pr_body=$(curl -s -H "Authorization: token ${{ secrets.GITHUB_TOKEN }}" \ | |
| "https://api.github.com/repos/${{ github.repository }}/pulls/${{ github.event.pull_request.number }}" | jq -r '.body') | |
| new_body="$pr_body<!-- pylon-ticket-id: ${{ env.ticket_id }} -->" | |
| json_body=$(jq -R -s --arg body "$new_body" '{"body": $body}' <<< "$new_body") | |
| curl -X PATCH -H "Authorization: token ${{ secrets.GITHUB_TOKEN }}" \ | |
| -H "Content-Type: application/json" \ | |
| -d "$json_body" \ | |
| "https://api.github.com/repos/${{ github.repository }}/pulls/${{ github.event.pull_request.number }}" |