BigQuery Management
63 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What should be done after identifying a cancelled client in the BigQuery system?

  • Save their queries to the tracker data file. (correct)
  • Archive their queries in the All Clients Latest Query.
  • Highlight their data in blue.
  • Delete all their information from the system.

    • What is the purpose of highlighting data in red in the tracker data file?

  • To mark queries that need to be reviewed later.
  • To signify that the data has been archived.
  • To inform the Terakar dev team about removed queries. (correct)
  • To indicate a new query entry.

    • When checking client IDs, what should be done if a client has re-signed after cancellation?

  • Remove them from the new customer log.
  • Only keep their cancelled status.
  • Include them in the All Clients Latest Query. (correct)
  • Delete their previous data and create a new record.

    • Which of the following should be checked alongside the new customer log?

    <p>The search and creation log.</p> Signup and view all the answers

    What indicates that a client is no longer active?

    <p>They are not found in the new customer log or search and curation log.</p> Signup and view all the answers

    What should be done with clients identified as 'N.A.' in the new customer log?

    <p>They need to have their queries removed.</p> Signup and view all the answers

    Which software tool is used to verify the presence of client IDs?

    <p>BigQuery</p> Signup and view all the answers

    Which behavior might indicate a client is trying to return after cancellation?

    <p>Having a name in both cancelled and new customer logs.</p> Signup and view all the answers

    What is the first step in cleaning up the client queries?

    <p>Check the client IDs in the client intake form.</p> Signup and view all the answers

    Which task was deemed a priority when running BigQuery?

    <p>Removing queries from inactive clients.</p> Signup and view all the answers

    What is the first file needed for the process described?

    <p>BigQuery</p> Signup and view all the answers

    Which two files need to be opened simultaneously?

    <p>Client intake form and BigQuery</p> Signup and view all the answers

    What is the purpose of cleaning the BigQuery data?

    <p>To check which clients are active or cancelled</p> Signup and view all the answers

    What is the significance of copying client IDs from the bottom of the list?

    <p>To facilitate the selection of clients for processing</p> Signup and view all the answers

    What should be done before addressing any questions?

    <p>Finish the step-by-step procedure</p> Signup and view all the answers

    What is the role of the Client Intake Form in the cleaning process?

    <p>It tracks the client activity</p> Signup and view all the answers

    What action should be taken after the recording?

    <p>Create a document with the transcript</p> Signup and view all the answers

    How should the screen be shared during the process?

    <p>Share the entire screen</p> Signup and view all the answers

    Why was there a misunderstanding regarding the microphone?

    <p>One participant was muted</p> Signup and view all the answers

    What should be done if there is confusion during the discussion?

    <p>Ask for clarification immediately</p> Signup and view all the answers

    What is the purpose of using VLOOKUP in this context?

    <p>To check if client IDs are in the list of canceled clients</p> Signup and view all the answers

    What is the first step suggested for cleaning up the client ID data?

    <p>Remove all unnecessary information and keep only the client IDs</p> Signup and view all the answers

    After copying a client ID, what is the next suggested action?

    <p>Search for the client ID in BigQuery</p> Signup and view all the answers

    What should be done after processing the canceled client IDs?

    <p>Highlight the rows of canceled clients in red</p> Signup and view all the answers

    Which method is suggested for removing entries in BigQuery?

    <p>Cut and paste entries to track them</p> Signup and view all the answers

    What caution is advised when dealing with client names that are similar?

    <p>Ensure the correct client ID is referenced to avoid mistakes</p> Signup and view all the answers

    What function is specifically mentioned to handle separating client IDs from other data?

    <p>SPLIT</p> Signup and view all the answers

    What indicates that a client has been deleted from BigQuery?

    <p>The client row highlighted in red</p> Signup and view all the answers

    How should unnecessary words or data be handled according to the instructions?

    <p>Remove them to only retain client IDs</p> Signup and view all the answers

    Which operation is NOT suggested after identifying canceled clients?

    <p>Retaining all data in the tracker file</p> Signup and view all the answers

    What is the first action to be undertaken in the cleaning process?

    <p>Access BigQuery's All Clients Latest</p> Signup and view all the answers

    Which two files are essential to open simultaneously during the cleaning process?

    <p>BigQuery and Client Intake Form</p> Signup and view all the answers

    What should be done prior to addressing any questions during the cleaning process?

    <p>Complete the step-by-step procedure first</p> Signup and view all the answers

    Why is it necessary to check the Client Intake Form during the cleaning process?

    <p>To determine if a client is active or has cancelled</p> Signup and view all the answers

    During the process, how should the screen be shared?

    <p>Share the entire screen</p> Signup and view all the answers

    What should be done to the client IDs in the BigQuery after they have been identified as cancelled?

    <p>They should be removed from BigQuery.</p> Signup and view all the answers

    Which is the correct function to use for checking whether client IDs are in the canceled clients list?

    <p>VLOOKUP</p> Signup and view all the answers

    What should be done after deleting client queries from BigQuery?

    <p>Highlight the corresponding rows in red.</p> Signup and view all the answers

    What is the main step involved in separating client IDs from other data in BigQuery?

    <p>Splitting the text to columns.</p> Signup and view all the answers

    When identifying the client query entries, what is essential to avoid confusion with similar names?

    <p>Always use full names including surnames.</p> Signup and view all the answers

    What should be done first when updating BigQuery?

    <p>Identify highlighted rows in the tracker data</p> Signup and view all the answers

    What action is required after replacing a client's query in BigQuery?

    <p>Remove the highlight from the replaced entry</p> Signup and view all the answers

    What should be done if a new client does not have an existing query in BigQuery?

    <p>Add the client's query at the bottom of the list</p> Signup and view all the answers

    When should the 'Select to Union All' command be used during the updating process?

    <p>Immediately after replacing any client query</p> Signup and view all the answers

    What characteristic distinguishes rows that need edits in the tracker data?

    <p>They are highlighted in yellow</p> Signup and view all the answers

    What is the final step to ensure changes are saved in BigQuery?

    <p>Save the updated query</p> Signup and view all the answers

    If a client entry is already present in the all clients latest query and there's a new query for that client, what should be done?

    <p>Replace the old query with the new one</p> Signup and view all the answers

    What is the purpose of highlighting rows in yellow in the tracker data?

    <p>To mark entries for immediate review</p> Signup and view all the answers

    What should be done with entries highlighted in yellow in the query?

    <p>Add them to the All Clients Latest Query.</p> Signup and view all the answers

    How are queries marked for removal indicated?

    <p>They are highlighted in red after removal.</p> Signup and view all the answers

    What should be confirmed to check if new data has arrived?

    <p>Check Google Cloud Storage for today's date.</p> Signup and view all the answers

    What is the purpose of using chat GPT in the documentation process?

    <p>To summarize and create step-by-step procedures.</p> Signup and view all the answers

    What is the recommended method for handling the transcript before documentation?

    <p>Input it into chat GPT and edit afterwards.</p> Signup and view all the answers

    What is the first step to take in the VM Instances window?

    <p>Select the VM instance and click on SSH.</p> Signup and view all the answers

    How long does the script 'load_json_to_bq.sh' typically take to finish running?

    <p>4 minutes</p> Signup and view all the answers

    What should be done after running the SQL query in BigQuery?

    <p>Switch to the Cloud Functions window.</p> Signup and view all the answers

    Which command is NOT used in the SSH terminal after navigating to the ai-enric directory?

    <p>mkdir new_directory</p> Signup and view all the answers

    What should be done to avoid data duplication or incorrect entries in the Tracker Data Spreadsheet?

    <p>Empty the data from two specific tabs.</p> Signup and view all the answers

    What action must be taken to run the function in Cloud Functions?

    <p>Test the function by clicking the blue button.</p> Signup and view all the answers

    Which command creates a new screen session in the SSH terminal?

    <p>screen</p> Signup and view all the answers

    After closing SSH, what command should be re-entered to monitor logs?

    <p>tail -f *.log</p> Signup and view all the answers

    How should the output of the AI matching script be described in terms of performance?

    <p>Its performance is steady and takes about 1 second per row.</p> Signup and view all the answers

    What action follows clearing the data in the Tracker Data Spreadsheet?

    <p>Test the Export Baquerry function.</p> Signup and view all the answers

    Study Notes

    Data Cleaning Procedure for BigQuery

    • Tools Required: BigQuery, traffic tracker data file, client intake form file
    • Initial Steps: Open BigQuery, All Clients Latest Files. Clean BigQuery
    • Simultaneous Viewing: View BigQuery and Client Intake Form side-by-side.
    • Client Status Check: Use the Client Intake Form to identify cancelled or active clients.
    • Copy Client IDs: Copy all client IDs from the bottom of the All Clients Latest BigQuery list.
    • Create New Sheet: Create a new sheet (e.g., December 5, BQ Client IDs) to store the client IDs.
    • Extract Client IDs: Paste client IDs and separate them from extraneous text using data tools (e.g., 'Split text to columns').
    • Sort Client IDs: Sort the client IDs alphabetically in a column.
    • Identify Cancelled Clients: Cross-reference client IDs in the sorted list with the “Canceled Clients” tab to find canceled client IDs.
    • Remove Cancelled Clients' Queries: Remove IDs marked as cancelled from the BigQuery, avoiding deletion of active client IDs.
    • Transfer Queries to Tracker Data: Copy and paste client IDs found in the canceled client list into the Tracker data, replacing the corresponding query.
    • Delete from BigQuery: Delete client queries from BigQuery linked to canceled IDs ensuring no active client is removed.

    Additional Considerations

    • Highlight Canceled Clients: In the tracker data file, highlight rows of canceled clients in red, providing visual cues to the team.
    • Handle Duplicate Names: Be mindful of duplicate names when removing clients from BigQuery. Ensure you do not remove queries for clients with the same name but different IDs.
    • Old Clients: Delete queries for clients who are no longer active but were in the BigQuery query.
    • New Customers: Cross-reference and remove client IDs not present in the new customer log for potentially inactive clients.
    • Search and Creation Log Check: Check if client IDs are also in the search and creation log; if present, ensure queries are not deleted, and highlight rows.
    • Active Client Verification: Add or update client IDs in new customer log that may have been inaccurately marked as inactive to keep active clients in the query.

    Finalizing the Process

    • Check for Hidden Rows: Always check for hidden rows in Tracker data files.

    • Removal of N/A clients: Remove client IDs that are not present in the new customer or search and curation logs, indicating potentially inactive clients.

    • Highlighting Prioritization: Prioritize highlighting removed IDs in red for visibility and communication across the tracker team.

    • Ensure Completeness: Review and verify that all necessary steps are taken before running the BigQuery query to avoid errors.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    This quiz covers the essential steps for cleaning and organizing client data using BigQuery.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser