효율적인 데이터 동기화를 보장하기 위해 시스템은 스테이징 데이터 세트를 자동으로 생성하고 관리합니다. 이러한 데이터 세트는 fivetran_{두 개의 무작위 단어}_staging과 같은 패턴으로 이름이 지정되며, 기본 스키마에 통합되기 전에 처리 중에 데이터를 임시로 저장합니다. 이러한 스테이징 데이터 세트는 간소화된 워크플로를 유지하는 데 필수적이며 자동으로 다시 생성되므로 삭제하면 안 됩니다.
BigQuery event table columns를 OneSignal의 사용자 지정 이벤트 형식에 매핑합니다:
OneSignal 필드
BigQuery Column
설명
필수
name
event_name
이벤트 식별자
Yes
external_id
user_id
사용자 식별자
Yes
timestamp
event_timestamp
이벤트가 발생한 시간
No
properties
event_data
Additional columns as JSON
No
Sync Key는 동기화 중 각 행의 고유 식별자로 지정하는 열입니다. OneSignal은 이를 사용하여 행이 이미 처리되었는지 감지하므로, 데이터를 다시 동기화해도 중복 이벤트가 생성되지 않습니다. 행마다 고유한 텍스트 값을 가진 열을 선택하세요. 불리언 값이나 여러 행에서 반복되는 값은 사용하지 마세요.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"OneSignal Documentation","description":"OneSignal is a platform for sending push notifications, emails, in-app messages, and SMS campaigns via a single API, Journey Builder, and a dashboard.","colors":{"primary":"#3A3DB3","light":"#E54B4D","dark":"#3A3DB3"},"logo":{"light":"https://mintcdn.com/onesignal/yJcueeDCO7UpHnnY/logo/OneSignal-Logo.svg?fit=max\u0026auto=format\u0026n=yJcueeDCO7UpHnnY\u0026q=85\u0026s=1fcfb6fef6d820fd9d99c74850711107","dark":"https://mintcdn.com/onesignal/s4WC_KzLxf8ornqq/logo/OneSignal-Logo-White.svg?fit=max\u0026auto=format\u0026n=s4WC_KzLxf8ornqq\u0026q=85\u0026s=2573a53b5aea961e18c82b3af8f31925"},"favicon":"https://mintcdn.com/onesignal/SGduBFHpiRdg5l6h/favicon.ico?fit=max\u0026auto=format\u0026n=SGduBFHpiRdg5l6h\u0026q=85\u0026s=c0a99fadc0553c658a83741c5611cef4","api":{"examples":{"languages":["curl","typescript","python","php","go","ruby","java","csharp","rust"],"autogenerate":true}},"navbar":{"links":[{"href":"mailto:support@onesignal.com","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://dashboard.onesignal.com"}},"footer":{"socials":{"github":"https://github.com/OneSignal","linkedin":"https://linkedin.com/company/onesignal","youtube":"https://www.youtube.com/@onesignalofficial/playlists"}},"seo":{"metatags":{"apple-mobile-web-app-title":"OneSignal Docs"}},"fonts":{"family":"Nunito Sans"},"styling":{"eyebrows":"breadcrumbs","latex":true},"integrations":{"ga4":{"measurementId":"G-2DGWL0VYP5"},"posthog":{"apiKey":"phc_vZpvE0f5eyzcOt30FHer34yddVmNdo9kmlMVRBzLMtn","apiHost":"https://eu.i.posthog.com","sessionRecording":true}},"contextual":{"options":["copy","view","chatgpt","claude"],"display":"header"},"navigation":{"languages":[{"language":"en","href":"docs/en/home"},{"language":"cn","href":"docs/cn/home"},{"language":"ko","href":"docs/ko/home"},{"language":"ja","href":"docs/ja/home"},{"language":"tr","href":"docs/tr/home"},{"language":"pt-BR","href":"docs/pt-BR/home"},{"language":"es","href":"docs/es/home"},{"language":"fr","href":"docs/fr/home"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"onesignal","hasAudioNarration":false,"actualSubdomain":"onesignal","customDomains":["documentation.onesignal.com"],"gitSource":{"type":"github","owner":"onesignal","repo":"mintlify-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af3b762ba298f9b99480a99","clientVersion":"0.0.4102","searchFilterCounts":[{"language":"en","tag":"User Guides","count":204},{"language":"es","tag":"Guías del Usuario","count":178},{"language":"fr","tag":"Guides utilisateur","count":178},{"language":"ja","tag":"ユーザーガイド","count":178},{"language":"ko","tag":"사용자 가이드","count":178},{"language":"pt-BR","tag":"Guia do Usuário","count":178},{"language":"tr","tag":"Kullanıcı Kılavuzları","count":178},{"language":"cn","tag":"用户指南","count":176},{"language":"en","tag":"Message channels","count":90},{"language":"es","tag":"Canales de mensajería","count":84},{"language":"fr","tag":"Canaux de messagerie","count":84},{"language":"ja","tag":"メッセージングチャネル","count":84},{"language":"ko","tag":"메시지 채널","count":84},{"language":"pt-BR","tag":"Canais de mensagem","count":84},{"language":"tr","tag":"Mesaj kanalları","count":84},{"language":"cn","tag":"消息渠道","count":83},{"language":"default","tag":"API Reference","count":68},{"language":"default","tag":"API reference","count":64},{"language":"en","tag":"Analytics \u0026 Integrations","count":53},{"language":"es","tag":"Analítica \u0026 Integraciones","count":52},{"language":"fr","tag":"Analyses et intégrations","count":52},{"language":"ja","tag":"分析 \u0026 統合","count":52},{"language":"ko","tag":"분석 \u0026 통합","count":52},{"language":"pt-BR","tag":"Análises \u0026 Integrações","count":52},{"language":"tr","tag":"Analitik ve Entegrasyonlar","count":52},{"language":"cn","tag":"分析和集成","count":51},{"language":"cn","tag":"开发者指南","count":48},{"language":"es","tag":"Guías del desarrollador","count":48},{"language":"fr","tag":"Guides développeur","count":48},{"language":"ja","tag":"開発者ガイド","count":48},{"language":"ko","tag":"개발자 가이드","count":48},{"language":"tr","tag":"Geliştirici Kılavuzları","count":48},{"language":"en","tag":"Developer Guides","count":47},{"language":"pt-BR","tag":"Guia de desenvolvedor","count":47},{"language":"en","tag":"Integrations","count":37},{"language":"es","tag":"Integraciones","count":37},{"language":"fr","tag":"Intégrations","count":37},{"language":"ja","tag":"統合","count":37},{"language":"ko","tag":"통합","count":37},{"language":"pt-BR","tag":"Integrações","count":37},{"language":"tr","tag":"Entegrasyonlar","count":37},{"language":"cn","tag":"集成","count":36},{"language":"en","tag":"Tutorials","count":35},{"language":"cn","tag":"推送通知","count":31},{"language":"cn","tag":"OneSignal 作为目的地","count":31},{"language":"en","tag":"Push","count":31},{"language":"en","tag":"OneSignal as destination","count":31},{"language":"es","tag":"Push notificaciones","count":31},{"language":"es","tag":"OneSignal como destino","count":31},{"language":"fr","tag":"Push","count":31},{"language":"fr","tag":"OneSignal comme destination","count":31},{"language":"ja","tag":"プッシュ通知","count":31},{"language":"ja","tag":"OneSignal as 宛先","count":31},{"language":"ko","tag":"푸시","count":31},{"language":"ko","tag":"OneSignal을 데이터 목적지로 사용","count":31},{"language":"pt-BR","tag":"Push notificações","count":31},{"language":"pt-BR","tag":"OneSignal como destino","count":31},{"language":"tr","tag":"Anlık bildirimler","count":31},{"language":"tr","tag":"OneSignal hedef","count":31},{"language":"en","tag":"Mobile SDKs","count":26},{"language":"cn","tag":"移动SDK","count":25},{"language":"es","tag":"SDKs móviles","count":25},{"language":"fr","tag":"SDK mobiles","count":25},{"language":"ja","tag":"モバイルSDK","count":25},{"language":"ko","tag":"모바일 SDKs","count":25},{"language":"pt-BR","tag":"SDKs móveis","count":25},{"language":"tr","tag":"Mobil SDK'lar","count":25},{"language":"cn","tag":"教程","count":24},{"language":"es","tag":"Tutoriales","count":24},{"language":"fr","tag":"Tutoriels","count":24},{"language":"ja","tag":"チュートリアル","count":24},{"language":"ko","tag":"튜토리얼","count":24},{"language":"pt-BR","tag":"Tutoriais","count":24},{"language":"tr","tag":"Eğitimler","count":24},{"language":"en","tag":"Mobile SDK setup","count":19},{"language":"cn","tag":"移动SDK设置","count":18},{"language":"es","tag":"Configuración del SDK móvil","count":18},{"language":"fr","tag":"Configuration SDK mobile","count":18},{"language":"ja","tag":"モバイルSDKセットアップ","count":18},{"language":"ko","tag":"모바일 SDK 설정","count":18},{"language":"pt-BR","tag":"Configuração do SDK móvel","count":18},{"language":"tr","tag":"Mobil SDK kurulumu","count":18},{"language":"default","tag":"Messages","count":9},{"language":"default","tag":"Users","count":9},{"language":"default","tag":"Organization","count":9},{"language":"default","tag":"Journeys","count":8},{"language":"default","tag":"Deprecated","count":6},{"language":"default","tag":"Templates","count":6},{"language":"default","tag":"Subscriptions","count":6},{"language":"default","tag":"Segments","count":5}]},"assistantConfig":{"enableStarterQuestions":false,"deflection":{"enabled":true,"email":"support@onesignal.com","showHelpButton":true}},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[],"page":{"pagePath":"docs/ko/bigquery","slug":"/docs/ko/bigquery","pageMetadata":{"title":"Google BigQuery","description":"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.","keywords":["bigquery","google bigquery","BigQuery 통합","BigQuery 이벤트 가져오기","BigQuery 메시징 이벤트","행동 이벤트 동기화","GCP 통합","사용자 지정 이벤트 트리거"],"href":"/docs/ko/bigquery"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];const PLATFORM_0=`BigQuery`;const DATA_TYPE_0=`event table columns`;const COLUMN_HEADER_0=`BigQuery Column`;const PROPERTIES_DESCRIPTION_0=`Additional columns as JSON`;function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,hr:`hr`,li:`li`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Frame,Heading,Info,Note,OptimizedImage,Step,Steps,Table,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`개요`,children:`개요`}),`\n`,_jsx(_components.p,{children:`OneSignal + BigQuery 통합은 두 가지 강력한 데이터 파이프라인을 지원합니다:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`내보내기`}),`: OneSignal의 메시징 이벤트 데이터(푸시, 이메일, SMS, 인앱)를 BigQuery로 자동으로 전송하여 분석 및 보고합니다.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`가져오기`}),`: BigQuery 데이터 세트의 사용자 지정 사용자 이벤트를 OneSignal로 동기화하여 자동화된 Journeys 및 개인화된 메시징을 트리거합니다.`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`함께 사용하면 이러한 통합을 통해 사용자 참여 데이터를 완전히 제어하여 고급 분석 및 실시간 행동 기반 메시징을 지원합니다.`}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`onesignal-이벤트를-bigquery로-내보내기`,children:`OneSignal 이벤트를 BigQuery로 내보내기`}),`\n`,_jsx(_components.p,{children:`메시징 성능 및 참여 이벤트(예: 전송, 열기, 클릭)를 BigQuery로 전송하여:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`사용자 지정 대시보드 및 보고서 구축`}),`\n`,_jsx(_components.li,{children:`채널 전반에 걸친 전달 및 참여 추세 추적`}),`\n`,_jsx(_components.li,{children:`분석을 위해 OneSignal 데이터를 다른 비즈니스 데이터와 결합`}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`요구 사항`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`Access to `,_jsx(_components.a,{href:`/docs/en/event-streams`,children:`Event Streams`}),` for outbound message events (Plan limitations and overages apply)`]}),`\n`,_jsxs(_components.li,{children:[`Access to `,_jsx(_components.a,{href:`/docs/en/custom-events`,children:`Custom Events`}),` for inbound event syncing (Plan limitations and overages apply)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`https://onesignal.com/pricing`,children:`Updated Account Plan`}),` (not available on free apps)`]}),`\n`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`청구가 활성화된`}),` Google Cloud Platform 프로젝트`]}),`\n`,_jsx(_components.li,{children:`GCP 프로젝트에서 활성화된 BigQuery`}),`\n`,_jsx(_components.li,{children:`BigQuery 쓰기 권한이 있는 서비스 계정`}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`설정 단계`})}),`\n`,_jsx(Heading,{level:`3`,id:`1-서비스-계정-만들기`,children:`1. 서비스 계정 만들기`}),`\n`,_jsxs(Steps,{children:[_jsxs(Step,{title:`Google Cloud Platform 계정에 로그인`,children:[_jsx(_components.p,{children:`로그인한 후 적절한 프로젝트가 선택되었는지 확인합니다.`}),_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=038779c4d976ba56a17a32f2e6646573`,\"data-og-width\":`2388`,width:`2388`,\"data-og-height\":`558`,height:`558`,\"data-path\":`images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=4992dd34351cc1f8da0b35ea655bceb7 280w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=0c922d4fe6b58f19d4314524803da04f 560w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=5b4454722fc0bf2b6af39664b6f1450b 840w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=e92fd814a9971ec2410aeccb2434ef36 1100w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=5830a85d871d5ba41b3ce617387f283c 1650w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=49ed23fe6b58c03e5d0bddb467905d7e 2500w`})})]}),_jsxs(Step,{title:`서비스 계정 만들기`,children:[_jsxs(_components.p,{children:[_jsx(_components.a,{href:`https://console.cloud.google.com/iam-admin/serviceaccounts/create`,children:`서비스 계정 만들기 페이지`}),`를 방문하고 `,_jsx(_components.strong,{children:`서비스 계정 만들기`}),`를 클릭합니다.`]}),_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=038779c4d976ba56a17a32f2e6646573`,\"data-og-width\":`2388`,width:`2388`,\"data-og-height\":`558`,height:`558`,\"data-path\":`images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=4992dd34351cc1f8da0b35ea655bceb7 280w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=0c922d4fe6b58f19d4314524803da04f 560w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=5b4454722fc0bf2b6af39664b6f1450b 840w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=e92fd814a9971ec2410aeccb2434ef36 1100w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=5830a85d871d5ba41b3ce617387f283c 1650w, https://mintcdn.com/onesignal/0qspEXXeJ8zJbkJ-/images/docs/7fe257f51fcacd15a07c4f4f23bf8bf2f9f22c2f1c171ad8b8648624de4de304-BQ1-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=0qspEXXeJ8zJbkJ-\u0026q=85\u0026s=49ed23fe6b58c03e5d0bddb467905d7e 2500w`})})]}),_jsxs(Step,{title:`필드 작성`,children:[_jsx(_components.p,{children:`원하는 이름과 서비스 계정 ID를 지정합니다.`}),_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=37236688a79f1c16c0d6fdad15b03245`,\"data-og-width\":`1344`,width:`1344`,\"data-og-height\":`870`,height:`870`,\"data-path\":`images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=280\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=1e3ffac7b0476ef623641d41c20845b3 280w, https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=560\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=24ef862a49afc22c4d5e31e83e6afad4 560w, https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=840\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=1cca3fa7728e60c77b755e56df4cea8f 840w, https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=1100\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=5486c2cfed9d0b999ac638e1f2c9ac12 1100w, https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=1650\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=1542539c8911f8da0f9916f9b7c39dc5 1650w, https://mintcdn.com/onesignal/MUgio66t0sYhGEvj/images/docs/6437e9849e23f18ec6f90e03c3821817566e7f150125f440a58fbe5fd2b42e0b-BQ1-3.png?w=2500\u0026fit=max\u0026auto=format\u0026n=MUgio66t0sYhGEvj\u0026q=85\u0026s=02e4c6e47f1dcfd909e6c5bf3a3af434 2500w`})})]}),_jsxs(Step,{title:`'BigQuery User' 역할 할당`,children:[_jsx(_components.p,{children:`서비스 계정에 “BigQuery User” 역할을 부여합니다.`}),_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=1df75028d3632a3ed413c10c1de9b94a`,\"data-og-width\":`549`,width:`549`,\"data-og-height\":`395`,height:`395`,\"data-path\":`images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=280\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=0fe0bf5b41f084cd6f9f968e9ee6187d 280w, https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=560\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=12f8fa13c1011ea490a385b997118091 560w, https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=840\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=27a1bd853da856c972600ac1761a2c5a 840w, https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=1100\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=6bbc629a61a061ff1665a53ac9d80cc6 1100w, https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=1650\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=09156a2d85cf38f2649a7a9d9e490cfc 1650w, https://mintcdn.com/onesignal/56ctKxZSV4m5VEkn/images/docs/b1bff32d7f010b488b60347e01ecb1fbde182602f19f16d3d89914d1de1c0635-BQ1-4.png?w=2500\u0026fit=max\u0026auto=format\u0026n=56ctKxZSV4m5VEkn\u0026q=85\u0026s=731da05da2840cf860317fa2f3a36ed2 2500w`})})]}),_jsx(Step,{title:`이 계정에 대한 JSON 키 만들기`,children:_jsxs(_components.p,{children:[`새 서비스 계정 > `,_jsx(_components.strong,{children:`키`}),` > `,_jsx(_components.strong,{children:`키 추가`}),` > `,_jsx(_components.strong,{children:`새 키 만들기`}),`로 이동하여 JSON을 선택합니다. 파일을 저장합니다.`]})})]}),`\n`,_jsx(Info,{children:_jsx(_components.p,{children:`이 JSON 키 파일의 전체 내용을 OneSignal에 붙여넣어 통합을 활성화합니다.`})}),`\n`,_jsx(Heading,{level:`3`,id:`2-onesignal에서-통합-활성화`,children:`2. OneSignal에서 통합 활성화`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`OneSignal > 데이터 > 통합 > BigQuery로 이동`}),_jsx(Step,{title:`서비스 계정 JSON 키 붙여넣기`}),_jsx(Step,{title:`설정 구성`,children:_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`동기화 빈도`}),`: 15분마다 동기화 가능`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`데이터 세트/테이블 이름`}),`: 소문자, 숫자 및 밑줄만 포함해야 하며 숫자로 시작할 수 없습니다.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`이벤트 유형`}),`: 특정 메시지 이벤트 선택(예: 전송됨, 열림, 클릭됨)`,`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`참고:`}),` 여러 이벤트 유형을 선택하거나 나중에 선택한 이벤트를 업데이트할 수 있습니다.`]}),`\n`]}),`\n`]}),`\n`]})}),_jsx(Step,{title:`저장을 클릭하고 확인 대기`})]}),`\n`,_jsxs(Note,{children:[_jsx(_components.p,{children:`초기 데이터 동기화는 BigQuery에 나타나는 데 15-30분이 걸릴 수 있습니다.`}),_jsx(_components.p,{children:`대기하는 동안 푸시, 이메일, 인앱 또는 SMS를 통해 메시지를 보내 선택한 이벤트를 트리거하세요.`})]}),`\n`,_jsx(Heading,{level:`3`,id:`3-bigquery에서-데이터-보기`,children:`3. BigQuery에서 데이터 보기`}),`\n`,_jsxs(_components.p,{children:[`BigQuery 콘솔을 열고 데이터 세트(예: `,_jsx(_components.code,{children:`onesignal_events_\u003capp-id>`}),`)를 찾아 동기화된 메시지 이벤트를 탐색합니다.`]}),`\n`,_jsx(Frame,{caption:`BigQuery dataset containing exported message events`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=08cf57a8bd91f9447909ad619077935f`,\"data-og-width\":`1552`,width:`1552`,\"data-og-height\":`1052`,height:`1052`,\"data-path\":`images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=280\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=9feefc622c45a02b34a180b1174604ae 280w, https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=560\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=c66f03083f17ab36c95c899daf836bd6 560w, https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=840\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=fa0a00adfec275edabf4765b0d27ab93 840w, https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=1100\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=e4812a543993b5c37c05fe91197f3595 1100w, https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=1650\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=9faf4ea40912f4ab71db288c5dcb92f5 1650w, https://mintcdn.com/onesignal/9_Q1FZLh6C0BFLq-/images/docs/c40ec987eadef5dd1c16cb47fb71c2c666b30ea8667624584ecbc481c12ef026-BQ5.png?w=2500\u0026fit=max\u0026auto=format\u0026n=9_Q1FZLh6C0BFLq-\u0026q=85\u0026s=e5ccb18b4f5696d1136520ddde7ae537 2500w`})}),`\n`,_jsx(Heading,{level:`2`,id:`메시지-이벤트-및-속성`,children:`메시지 이벤트 및 속성`}),`\n`,_jsx(Heading,{level:`3`,id:`메시지-이벤트-종류`,children:`메시지 이벤트 종류`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`속성:`}),` `,_jsx(_components.code,{children:`event_kind`}),`\n`,_jsx(_components.strong,{children:`유형:`}),` `,_jsx(_components.code,{children:`String`})]}),`\n`,_jsxs(_components.p,{children:[`메시지 및 이벤트의 종류(예: `,_jsx(_components.code,{children:`message.push.received`}),`, `,_jsx(_components.code,{children:`message.push.sent`}),`).`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`center`},children:`메시지 이벤트 (OneSignal)`}),_jsx(_components.th,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`event_kind`})}),_jsx(_components.th,{children:`설명`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Push Sent`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.push.sent`})}),_jsx(_components.td,{children:`푸시 알림이 성공적으로 전송되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Push Received`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.push.received`})}),_jsxs(_components.td,{children:[`전달된 푸시(`,_jsx(_components.a,{href:`/docs/ko/confirmed-delivery`,children:`전달 확인`}),` 참조).`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Push Clicked`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.push.clicked`})}),_jsx(_components.td,{children:`사용자가 푸시를 클릭했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Push Failed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.push.failed`})}),_jsx(_components.td,{children:`전달 실패. 메시지 보고서를 참조하세요.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Push Unsubscribed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.push.unsubscribed`})}),_jsx(_components.td,{children:`사용자가 푸시 구독을 취소했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`In-App Impression`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.iam.impression`})}),_jsx(_components.td,{children:`인앱 메시지가 표시되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`In-App Clicked`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.iam.clicked`})}),_jsx(_components.td,{children:`인앱 메시지를 클릭했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`In-App Page Viewed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.iam.page_displayed`})}),_jsx(_components.td,{children:`인앱 페이지가 표시되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Sent`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.sent`})}),_jsx(_components.td,{children:`이메일이 전달되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Received`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.received`})}),_jsx(_components.td,{children:`수신자의 메일 서버가 이메일을 수락했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Opened`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.opened`})}),_jsxs(_components.td,{children:[`이메일이 열렸습니다. `,_jsx(_components.a,{href:`/docs/ko/email-message-reports`,children:`이메일 보고서`}),`를 참조하세요.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Link Clicked`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.clicked`})}),_jsx(_components.td,{children:`이메일의 링크를 클릭했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Unsubscribed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.unsubscribed`})}),_jsx(_components.td,{children:`수신자가 구독을 취소했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Reported As Spam`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.reported_as_spam`})}),_jsxs(_components.td,{children:[`스팸으로 표시되었습니다. `,_jsx(_components.a,{href:`/docs/ko/email-deliverability`,children:`이메일 전달 가능성`}),`을 참조하세요.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Bounced`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.bounced`})}),_jsx(_components.td,{children:`영구적인 전달 실패로 인한 반송.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Failed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.failed`})}),_jsx(_components.td,{children:`전달이 실패했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`Email Suppressed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.email.suppressed`})}),_jsx(_components.td,{children:`억제 목록으로 인해 억제되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`SMS Sent`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.sms.sent`})}),_jsx(_components.td,{children:`SMS가 전송되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`SMS Delivered`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.sms.delivered`})}),_jsx(_components.td,{children:`SMS가 성공적으로 전달되었습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`SMS Failed`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.sms.failed`})}),_jsx(_components.td,{children:`SMS 전달이 실패했습니다.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:`SMS Undelivered`}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message.sms.undelivered`})}),_jsx(_components.td,{children:`SMS가 거부되었거나 도달할 수 없습니다.`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`이벤트-데이터-스키마`,children:`이벤트 데이터 스키마`}),`\n`,_jsx(_components.p,{children:`사용자가 생성한 각 메시지 이벤트에 대해 다음 메타데이터가 레코드에 첨부됩니다.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`center`},children:`열 이름`}),_jsx(_components.th,{style:{textAlign:`center`},children:`유형`}),_jsx(_components.th,{children:`설명`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`event_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`이벤트의 고유 식별자`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`event_timestamp`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`Timestamp`}),_jsx(_components.td,{children:`이벤트 발생 시간`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`event_kind`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:_jsx(_components.a,{href:`#%EB%A9%94%EC%8B%9C%EC%A7%80-%EC%9D%B4%EB%B2%A4%ED%8A%B8-%EC%A2%85%EB%A5%98`,children:`이벤트 종류`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`subscription_device_type`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`장치 유형(예: iOS, Android, Web, Email, SMS)`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`language`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`구독 언어 코드`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`version`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`통합 버전`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`device_os`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`장치 운영 체제 버전`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`device_type`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`Number`}),_jsx(_components.td,{children:`숫자 장치 유형`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`token`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`푸시 토큰, 전화번호 또는 이메일`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`subscription_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`구독 ID`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`subscribed`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`Boolean`}),_jsx(_components.td,{children:`구독 상태`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`onesignal_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`OneSignal 사용자 ID`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`last_active`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`마지막 활성 타임스탬프`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`sdk`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`OneSignal SDK 버전`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`external_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`통합 사용자 ID와 일치해야 하는 외부 사용자 ID`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`app_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`OneSignal의 앱 ID`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`template_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`템플릿 ID(해당하는 경우)`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message_id`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`UUID`}),_jsx(_components.td,{children:`메시지 배치/요청 ID`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message_name`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`메시지 이름`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message_title`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`메시지 제목(영어만)`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`message_contents`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`잘린 메시지 본문(영어만)`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.code,{children:`failure_reason`})}),_jsx(_components.td,{style:{textAlign:`center`},children:`String`}),_jsx(_components.td,{children:`실패 이유(푸시 실패 및 이메일 실패 이벤트용)`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{style:{textAlign:`center`},children:[_jsx(_components.code,{children:`_created`}),`, `,_jsx(_components.code,{children:`_id`}),`, `,_jsx(_components.code,{children:`_index`}),`, `,_jsx(_components.code,{children:`_fivetran_synced`})]}),_jsx(_components.td,{style:{textAlign:`center`},children:_jsx(_components.em,{children:`내부 사용`})}),_jsx(_components.td,{children:`Fivetran 동기화 메타데이터`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`참고-사항`,children:`참고 사항`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`저장/활성화 후 동기화는 완료하는 데 추가로 15-30분이 소요될 수 있습니다.`}),`\n`,_jsx(_components.li,{children:`비활성화하면 비활성화 후 최종 동기화가 한 번 더 발생할 수 있습니다.`}),`\n`,_jsxs(_components.li,{children:[`효율적인 데이터 동기화를 보장하기 위해 시스템은 스테이징 데이터 세트를 자동으로 생성하고 관리합니다. 이러한 데이터 세트는 `,_jsx(_components.code,{children:`fivetran_{두 개의 무작위 단어}_staging`}),`과 같은 패턴으로 이름이 지정되며, 기본 스키마에 통합되기 전에 처리 중에 데이터를 임시로 저장합니다. 이러한 스테이징 데이터 세트는 간소화된 워크플로를 유지하는 데 필수적이며 자동으로 다시 생성되므로 삭제하면 안 됩니다.`]}),`\n`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`bigquery에서-이벤트-가져오기`,children:`BigQuery에서 이벤트 가져오기`}),`\n`,_jsx(_components.p,{children:`BigQuery의 행동 이벤트 데이터를 OneSignal로 전송하여:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`사용자 활동을 기반으로 Journeys 트리거`}),`\n`,_jsx(_components.li,{children:`행동 데이터를 기반으로 메시징 개인화`}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`요구 사항`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`Access to `,_jsx(_components.a,{href:`/docs/en/event-streams`,children:`Event Streams`}),` for outbound message events (Plan limitations and overages apply)`]}),`\n`,_jsxs(_components.li,{children:[`Access to `,_jsx(_components.a,{href:`/docs/en/custom-events`,children:`Custom Events`}),` for inbound event syncing (Plan limitations and overages apply)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`https://onesignal.com/pricing`,children:`Updated Account Plan`}),` (not available on free apps)`]}),`\n`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`BigQuery 및 이벤트 데이터 테이블이 있는 GCP 프로젝트`}),`\n`,_jsx(_components.li,{children:`읽기 권한이 있는 서비스 계정`}),`\n`,_jsx(_components.li,{children:`BigQuery 데이터 세트에 행동 데이터가 포함된 이벤트 데이터 테이블`}),`\n`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.strong,{children:`설정 단계`})}),`\n`,_jsxs(Steps,{children:[_jsxs(Step,{title:`BigQuery 서비스 계정 만들기`,children:[_jsx(_components.p,{children:`OneSignal은 연결을 만들 때 자동으로 서비스 계정을 생성합니다. 또는 자체 서비스 계정 키 JSON 파일을 제공할 수 있습니다.`}),_jsx(_components.p,{children:`자체 서비스 계정을 만드는 경우 아래에 나열된 필수 권한이 있는지 확인하세요.`})]}),_jsxs(Step,{title:`필수 권한 부여`,children:[_jsx(_components.p,{children:`OneSignal 서비스 계정에는 다음 BigQuery IAM 역할이 필요합니다:`}),_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:_jsx(_components.code,{children:`bigquery.dataViewer`})}),` - 이벤트 데이터가 포함된 데이터 세트 및 테이블에 대한 읽기 액세스`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:_jsx(_components.code,{children:`bigquery.jobUser`})}),` - 데이터 쿼리를 위한 작업 생성 권한`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:_jsx(_components.code,{children:`bigquery.metadataViewer`})}),` - 프로젝트 수준 메타데이터 액세스(권장)`]}),`\n`]}),_jsx(_components.p,{children:`Google Cloud Console 또는 CLI를 사용하여 권한을 부여합니다:`}),_jsx(CodeBlock,{filename:``,numberOfLines:`7`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`7`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`gcloud`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` projects`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` add-iam-policy-binding`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_PROJECT_ID`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --member`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` serviceAccount:ONESIGNAL_SERVICE_ACCOUNT_EMAIL`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --role`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` roles/bigquery.dataViewer`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`gcloud`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` projects`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` add-iam-policy-binding`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_PROJECT_ID`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --member`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` serviceAccount:ONESIGNAL_SERVICE_ACCOUNT_EMAIL`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --role`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` roles/bigquery.jobUser`})]}),`\n`]})})})]}),_jsxs(Step,{title:`OneSignal에 통합 추가`,children:[_jsxs(_components.p,{children:[`OneSignal에서 `,_jsx(_components.strong,{children:`Data > Integrations`}),`으로 이동하여 `,_jsx(_components.strong,{children:`Add Integration`}),`을 클릭합니다.`]}),_jsx(Frame,{caption:`BigQuery 통합 추가`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=6877dc14cfe8f9c1677404353927e4f8`,\"data-og-width\":`1944`,width:`1944`,\"data-og-height\":`1764`,height:`1764`,\"data-path\":`images/integrations/bigquery-add-integration.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=280\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=0abb12695589e40318b3991021a94bd3 280w, https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=560\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=685e80480a19ef9179800bde74b30e98 560w, https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=840\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=1bc40038c83073222afa58229653996e 840w, https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=1100\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=9d128e0751c59422bd40356ef8989f5a 1100w, https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=1650\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=6d92310577290376ba30ba02deaa37de 1650w, https://mintcdn.com/onesignal/IHzVtEbivOs2EktQ/images/integrations/bigquery-add-integration.png?w=2500\u0026fit=max\u0026auto=format\u0026n=IHzVtEbivOs2EktQ\u0026q=85\u0026s=9689856c3c4821a25da21e935e7e9880 2500w`})}),_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`동기화 엔진`}),`: 대규모 데이터 세트 또는 복잡한 이벤트 데이터 쿼리에는 고급 동기화가 권장됩니다. 기본 동기화로 시작한 다음 필요한 경우 나중에 고급 동기화로 전환할 수 있습니다.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Google Cloud 프로젝트 ID`}),`: BigQuery 데이터 세트가 포함된 GCP 프로젝트`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`데이터 세트 지역`}),`: BigQuery 데이터 세트가 저장된 위치`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`서비스 계정 키`}),` (선택 사항): 자체 서비스 계정을 사용하는 경우 JSON 키 파일`]}),`\n`]})]}),_jsxs(Step,{title:`이벤트 데이터 소스 구성`,children:[_jsx(_components.p,{children:`이벤트 데이터가 포함된 BigQuery 데이터 세트 및 테이블을 지정합니다:`}),_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`데이터 세트`}),`: BigQuery 데이터 세트 이름(예: `,_jsx(_components.code,{children:`analytics_events`}),`)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`테이블/뷰`}),`: 이벤트 레코드가 포함된 테이블 또는 뷰`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`이벤트 쿼리`}),`: 이벤트 데이터를 필터링하거나 변환하기 위한 선택적 SQL 쿼리`]}),`\n`]}),_jsx(_components.p,{children:`이벤트 테이블에는 다음에 대한 열이 포함되어야 합니다:`}),_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`이벤트 이름/유형`}),`\n`,_jsx(_components.li,{children:`사용자 식별자`}),`\n`,_jsx(_components.li,{children:`이벤트 타임스탬프`}),`\n`,_jsx(_components.li,{children:`추가 이벤트 속성`}),`\n`]})]}),_jsx(Step,{title:`연결 테스트`,children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`연결 테스트`}),`를 클릭하여 OneSignal이 BigQuery 프로젝트에 액세스하고 이벤트 데이터를 읽을 수 있는지 확인합니다.`]})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`3`,id:`이벤트-데이터-매핑`,children:`이벤트 데이터 매핑`}),`\n`,_jsxs(_components.p,{children:[PLATFORM_0,` `,DATA_TYPE_0,`를 OneSignal의 사용자 지정 이벤트 형식에 매핑합니다:`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`OneSignal 필드`}),_jsx(_components.th,{children:COLUMN_HEADER_0}),_jsx(_components.th,{children:`설명`}),_jsx(_components.th,{children:`필수`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`name`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`event_name`})}),_jsx(_components.td,{children:`이벤트 식별자`}),_jsx(_components.td,{children:`Yes`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`external_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`user_id`})}),_jsx(_components.td,{children:`사용자 식별자`}),_jsx(_components.td,{children:`Yes`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`timestamp`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`event_timestamp`})}),_jsx(_components.td,{children:`이벤트가 발생한 시간`}),_jsx(_components.td,{children:`No`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`properties`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`event_data`})}),_jsx(_components.td,{children:PROPERTIES_DESCRIPTION_0}),_jsx(_components.td,{children:`No`})]})]})]}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Sync Key`}),`는 동기화 중 각 행의 고유 식별자로 지정하는 열입니다. OneSignal은 이를 사용하여 행이 이미 처리되었는지 감지하므로, 데이터를 다시 동기화해도 중복 이벤트가 생성되지 않습니다. 행마다 고유한 텍스트 값을 가진 열을 선택하세요. 불리언 값이나 여러 행에서 반복되는 값은 사용하지 마세요.`]})}),`\n`,_jsx(Heading,{level:`3`,id:`고급-구성`,children:`고급 구성`}),`\n`,_jsx(Heading,{level:`4`,id:`사용자-지정-sql-쿼리`,children:`사용자 지정 SQL 쿼리`}),`\n`,_jsx(_components.p,{children:`OneSignal로 동기화하기 전에 사용자 지정 SQL을 사용하여 이벤트 데이터를 필터링하거나 변환합니다:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`11`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`11`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` event_name,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` user_id,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` event_timestamp,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` STRUCT(`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` product_id,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` purchase_amount,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` category`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`as`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` payload`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:\" `project.dataset.events`\"})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WHERE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` event_timestamp `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>=`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` TIMESTAMP_SUB(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:`CURRENT_TIMESTAMP`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(), INTERVAL `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`7`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DAY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`4`,id:`교차-프로젝트-액세스`,children:`교차 프로젝트 액세스`}),`\n`,_jsx(_components.p,{children:`이벤트 데이터가 여러 BigQuery 프로젝트에 걸쳐 있는 경우 참조된 테이블 또는 뷰가 포함된 각 프로젝트에 OneSignal 서비스 계정 액세스를 부여합니다.`}),`\n`,_jsx(Warning,{children:_jsx(_components.p,{children:`최적의 성능을 위해 BigQuery 연결 지역이 특정 테이블 지역과 일치해야 합니다.`})}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`faq`,children:`FAQ`}),`\n`,_jsx(Heading,{level:`3`,id:`동기화가-실패하는-이유는-무엇인가요`,children:`동기화가 실패하는 이유는 무엇인가요?`}),`\n`,_jsx(_components.p,{children:`동기화가 실패하는 몇 가지 일반적인 이유가 있습니다:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`서비스 계정에 필요한 권한이 없습니다`}),`\n`,_jsx(_components.li,{children:`소스 데이터 세트가 기본 동기화에 비해 너무 크며 고급 동기화를 사용해야 합니다`}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`위의 설정 단계를 검토하고 올바르게 따랐는지 확인하세요. 여전히 문제가 있는 경우 `,_jsx(_components.code,{children:`support@onesignal.com`}),`에 문의하세요.`]}),`\n`,_jsx(Heading,{level:`3`,id:`동일한-콘텐츠에-대해-여러-메시지-id가-표시되는-이유는-무엇인가요`,children:`동일한 콘텐츠에 대해 여러 메시지 ID가 표시되는 이유는 무엇인가요?`}),`\n`,_jsx(_components.p,{children:`일반적으로 메시지 템플릿이 여러 전송 또는 트리거된 플로우에서 재사용될 때 발생합니다.`}),`\n`,_jsx(Heading,{level:`3`,id:`onesignal은-얼마나-자주-데이터를-동기화하나요`,children:`OneSignal은 얼마나 자주 데이터를 동기화하나요?`}),`\n`,_jsx(_components.p,{children:`내보내기 및 가져오기 통합 모두 15분마다 동기화할 수 있습니다.`}),`\n`,_jsx(Heading,{level:`3`,id:`bigquery-뷰를-사용할-수-있나요`,children:`BigQuery 뷰를 사용할 수 있나요?`}),`\n`,_jsx(_components.p,{children:`예. 서비스 계정이 뷰에서 참조된 모든 테이블에 액세스할 수 있는지 확인하기만 하면 됩니다.`}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`관련-리소스`,children:`관련 리소스`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`https://cloud.google.com/iam/docs/creating-managing-service-account-keys#creating`,children:`GCP에서 서비스 계정 키 만들기`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/docs/ko/journeys-overview`,children:`OneSignal Journeys 문서`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/docs/ko/exporting-data`,children:`OneSignal 데이터 내보내기 문서`})}),`\n`]}),`\n`,_jsx(_components.hr,{})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{PLATFORM_0,DATA_TYPE_0,COLUMN_HEADER_0,PROPERTIES_DESCRIPTION_0,default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Google BigQuery","description":"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.","keywords":["bigquery","google bigquery","BigQuery 통합","BigQuery 이벤트 가져오기","BigQuery 메시징 이벤트","행동 이벤트 동기화","GCP 통합","사용자 지정 이벤트 트리거"],"href":"/docs/ko/bigquery"}}},"mdxSourceWithNoJs":null,"noJsSplices":[[145,305,"undefined;const DATA_TYPE_0=undefined;const COLUMN_HEADER_0=undefined;const PROPERTIES_DESCRIPTION_0=undefined;function "],[37928,37958,"`BigQuery`,` `,`event table columns`,`를 "],[38164,38182,"`BigQuery Column`}),"],[39334,39370,"`Additional columns as JSON`}),_jsx(_com"]]},"mdxExtracts":{"tableOfContents":[{"title":"개요","slug":"개요","depth":2,"children":[]},{"title":"OneSignal 이벤트를 BigQuery로 내보내기","slug":"onesignal-이벤트를-bigquery로-내보내기","depth":2,"children":[{"title":"1. 서비스 계정 만들기","slug":"1-서비스-계정-만들기","depth":3,"children":[]},{"title":"2. OneSignal에서 통합 활성화","slug":"2-onesignal에서-통합-활성화","depth":3,"children":[]},{"title":"3. BigQuery에서 데이터 보기","slug":"3-bigquery에서-데이터-보기","depth":3,"children":[]}]},{"title":"메시지 이벤트 및 속성","slug":"메시지-이벤트-및-속성","depth":2,"children":[{"title":"메시지 이벤트 종류","slug":"메시지-이벤트-종류","depth":3,"children":[]},{"title":"이벤트 데이터 스키마","slug":"이벤트-데이터-스키마","depth":3,"children":[]},{"title":"참고 사항","slug":"참고-사항","depth":3,"children":[]}]},{"title":"BigQuery에서 이벤트 가져오기","slug":"bigquery에서-이벤트-가져오기","depth":2,"children":[{"title":"이벤트 데이터 매핑","slug":"이벤트-데이터-매핑","depth":3,"children":[]},{"title":"고급 구성","slug":"고급-구성","depth":3,"children":[]},{"title":"사용자 지정 SQL 쿼리","slug":"사용자-지정-sql-쿼리","depth":4,"children":[]},{"title":"교차 프로젝트 액세스","slug":"교차-프로젝트-액세스","depth":4,"children":[]}]},{"title":"FAQ","slug":"faq","depth":2,"children":[{"title":"동기화가 실패하는 이유는 무엇인가요?","slug":"동기화가-실패하는-이유는-무엇인가요","depth":3,"children":[]},{"title":"동일한 콘텐츠에 대해 여러 메시지 ID가 표시되는 이유는 무엇인가요?","slug":"동일한-콘텐츠에-대해-여러-메시지-id가-표시되는-이유는-무엇인가요","depth":3,"children":[]},{"title":"OneSignal은 얼마나 자주 데이터를 동기화하나요?","slug":"onesignal은-얼마나-자주-데이터를-동기화하나요","depth":3,"children":[]},{"title":"BigQuery 뷰를 사용할 수 있나요?","slug":"bigquery-뷰를-사용할-수-있나요","depth":3,"children":[]}]},{"title":"관련 리소스","slug":"관련-리소스","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/onesignal/e069c1b9f3157e14/hotjar-koala.js","/_mintlify/custom/onesignal/3e5d03885ab32f49/intercom.js","/_mintlify/custom/onesignal/dbb7af4794d1b586/munchkin-marketo.js"],"subdomain":"onesignal","siteName":"OneSignal Documentation","title":"Google BigQuery - OneSignal Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/docs/en/bigquery","matchLevel":1},"cn":{"href":"/docs/cn/bigquery","matchLevel":1},"ko":{"href":"/docs/ko/bigquery","matchLevel":0},"ja":{"href":"/docs/ja/bigquery","matchLevel":1},"tr":{"href":"/docs/tr/bigquery","matchLevel":1},"pt-BR":{"href":"/docs/pt-BR/bigquery","matchLevel":1},"es":{"href":"/docs/es/bigquery","matchLevel":1},"fr":{"href":"/docs/fr/bigquery","matchLevel":1}}},"lastModified":"2026-09-03T00:58:16.647Z","originalFileLocation":"docs/ko/bigquery.mdx","locale":"ko"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\">\u003cmeta data-mint-head name=\"application-name\" content=\"OneSignal Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Google BigQuery - OneSignal Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"OneSignal Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://documentation.onesignal.com/docs/ko/bigquery\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://onesignal.mintlify.site/_mintlify/api/og/v2?division=OneSignal%EC%9D%84+%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%86%8C%EC%8A%A4%EB%A1%9C+%EC%82%AC%EC%9A%A9\u0026amp;title=Google+BigQuery\u0026amp;description=%EB%A9%94%EC%8B%9C%EC%A7%95+%EC%9D%B4%EB%B2%A4%ED%8A%B8+%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC+BigQuery%EB%A1%9C+%EB%82%B4%EB%B3%B4%EB%82%B4%EA%B3%A0+BigQuery%EC%97%90%EC%84%9C+%EC%82%AC%EC%9A%A9%EC%9E%90+%EC%A7%80%EC%A0%95+%EC%9D%B4%EB%B2%A4%ED%8A%B8%EB%A5%BC+%EA%B0%80%EC%A0%B8%EC%99%80+%EA%B0%9C%EC%9D%B8%ED%99%94%EB%90%9C+%EC%BA%A0%ED%8E%98%EC%9D%B8%EC%9D%84+%ED%8A%B8%EB%A6%AC%EA%B1%B0%ED%95%98%EC%84%B8%EC%9A%94.\u0026amp;theme=12e705baa88dc8cc6d7a9877\u0026amp;signature=3bf64e1903c2dfdd137feadb8fe7ae347bb37490d460132ba008e0de76dd12e4\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Google BigQuery - OneSignal Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://onesignal.mintlify.site/_mintlify/api/og/v2?division=OneSignal%EC%9D%84+%EB%8D%B0%EC%9D%B4%ED%84%B0+%EC%86%8C%EC%8A%A4%EB%A1%9C+%EC%82%AC%EC%9A%A9\u0026amp;title=Google+BigQuery\u0026amp;description=%EB%A9%94%EC%8B%9C%EC%A7%95+%EC%9D%B4%EB%B2%A4%ED%8A%B8+%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC+BigQuery%EB%A1%9C+%EB%82%B4%EB%B3%B4%EB%82%B4%EA%B3%A0+BigQuery%EC%97%90%EC%84%9C+%EC%82%AC%EC%9A%A9%EC%9E%90+%EC%A7%80%EC%A0%95+%EC%9D%B4%EB%B2%A4%ED%8A%B8%EB%A5%BC+%EA%B0%80%EC%A0%B8%EC%99%80+%EA%B0%9C%EC%9D%B8%ED%99%94%EB%90%9C+%EC%BA%A0%ED%8E%98%EC%9D%B8%EC%9D%84+%ED%8A%B8%EB%A6%AC%EA%B1%B0%ED%95%98%EC%84%B8%EC%9A%94.\u0026amp;theme=12e705baa88dc8cc6d7a9877\u0026amp;signature=3bf64e1903c2dfdd137feadb8fe7ae347bb37490d460132ba008e0de76dd12e4\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/onesignal/eCiRydtW5fLfLRWp/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"OneSignal Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#3A3DB3\">\u003clink data-mint-head rel=\"canonical\" href=\"https://documentation.onesignal.com/docs/ko/bigquery\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/ko/bigquery.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://documentation.onesignal.com/docs/ko/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://documentation.onesignal.com/docs/en/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://documentation.onesignal.com/docs/cn/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://documentation.onesignal.com/docs/ja/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"tr\" href=\"https://documentation.onesignal.com/docs/tr/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt-BR\" href=\"https://documentation.onesignal.com/docs/pt-BR/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://documentation.onesignal.com/docs/es/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"fr\" href=\"https://documentation.onesignal.com/docs/fr/bigquery\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://documentation.onesignal.com/docs/en/bigquery\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://documentation.onesignal.com/#organization\",\"name\":\"OneSignal Documentation\",\"url\":\"https://documentation.onesignal.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/onesignal/yJcueeDCO7UpHnnY/logo/OneSignal-Logo.svg?fit=max\u0026auto=format\u0026n=yJcueeDCO7UpHnnY\u0026q=85\u0026s=1fcfb6fef6d820fd9d99c74850711107\"}},{\"@type\":\"WebSite\",\"@id\":\"https://documentation.onesignal.com#website\",\"name\":\"OneSignal Documentation\",\"url\":\"https://documentation.onesignal.com\",\"publisher\":{\"@id\":\"https://documentation.onesignal.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://documentation.onesignal.com/docs/ko/bigquery#webpage\",\"url\":\"https://documentation.onesignal.com/docs/ko/bigquery\",\"name\":\"Google BigQuery\",\"description\":\"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\",\"dateModified\":\"2026-09-03T00:58:16.647Z\",\"isPartOf\":{\"@id\":\"https://documentation.onesignal.com#website\"},\"breadcrumb\":{\"@id\":\"https://documentation.onesignal.com/docs/ko/bigquery#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://documentation.onesignal.com/docs/ko/bigquery#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"분석 \u0026 통합\",\"item\":\"https://documentation.onesignal.com/docs/ko/analytics-overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"통합\",\"item\":\"https://documentation.onesignal.com/docs/ko/integrations\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"OneSignal을 데이터 소스로 사용\",\"item\":\"https://documentation.onesignal.com/docs/ko/amplitude\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Google BigQuery\",\"item\":\"https://documentation.onesignal.com/docs/ko/bigquery\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://documentation.onesignal.com/docs/ko/bigquery#article\",\"headline\":\"Google BigQuery\",\"name\":\"Google BigQuery\",\"description\":\"메시징 이벤트 데이터를 BigQuery로 내보내고 BigQuery에서 사용자 지정 이벤트를 가져와 개인화된 캠페인을 트리거하세요.\",\"url\":\"https://documentation.onesignal.com/docs/ko/bigquery\",\"mainEntityOfPage\":{\"@id\":\"https://documentation.onesignal.com/docs/ko/bigquery#webpage\"},\"dateModified\":\"2026-09-03T00:58:16.647Z\",\"keywords\":\"bigquery, google bigquery, BigQuery 통합, BigQuery 이벤트 가져오기, BigQuery 메시징 이벤트, 행동 이벤트 동기화, GCP 통합, 사용자 지정 이벤트 트리거\",\"publisher\":{\"@id\":\"https://documentation.onesignal.com/#organization\"},\"isPartOf\":{\"@id\":\"https://documentation.onesignal.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"OneSignal Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"OneSignal Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/ko/bigquery.md","siteName":"OneSignal Documentation","nav":{"global":null,"languages":[{"language":"en","pages":[{"title":"en","href":"/docs/en/bigquery"}]},{"language":"cn","pages":[{"title":"cn","href":"/docs/cn/bigquery"}]},{"language":"ko","tabs":[{"tab":"홈","pages":[{"title":"홈","href":"/docs/ko/home"}]},{"tab":"사용자 가이드","groups":[{"group":"시작하기 \u0026 설정","pages":[{"title":"OneSignal 시작하기","href":"/docs/ko/quickstart-guide"},{"group":"OneSignal 대시보드","pages":[{"title":"앱, 조직 및 계정","href":"/docs/ko/apps-organizations"},{"title":"팀 멤버","href":"/docs/ko/manage-team-members"},{"title":"키 및 ID","href":"/docs/ko/keys-and-ids"},{"title":"감사 로그","href":"/docs/ko/audit-logs"},{"title":"사용량 및 청구","href":"/docs/ko/billing-faq"},{"title":"비활성화된 앱 및 조직","href":"/docs/ko/disabled-apps"}]},{"title":"OneSignal로 마이그레이션","href":"/docs/ko/migrating-to-onesignal"}]},{"group":"메시지 채널","pages":[{"title":"채널 설정","href":"/docs/ko/channel-setup"},{"group":"푸시","pages":[{"title":"푸시 개요","href":"/docs/ko/push"},{"group":"모바일 푸시","pages":[{"title":"모바일 푸시 설정","href":"/docs/ko/mobile-push-setup"},{"title":"푸시 권한 요청","href":"/docs/ko/prompt-for-push-permissions"},{"title":"iOS 임시 푸시 알림","href":"/docs/ko/ios-provisional-push-notifications"},{"title":"Android 알림 카테고리","href":"/docs/ko/android-notification-categories"},{"title":"데이터 및 백그라운드 알림","href":"/docs/ko/data-notifications"},{"title":"VoIP 푸시 알림","href":"/docs/ko/voip-notifications"}]},{"group":"웹 푸시","pages":[{"title":"웹 푸시 설정","href":"/docs/ko/web-push-setup"},{"title":"Web 권한 프롬프트","href":"/docs/ko/permission-requests"},{"title":"웹 푸시 FAQ","href":"/docs/ko/web-push-setup-faq"},{"title":"웹 푸시 브라우저 동작","href":"/docs/ko/browser-behavior-and-unsubscribes"},{"title":"Shopify 웹 푸시 통합","href":"/docs/ko/shopify"},{"title":"웹 푸시를 위한 OneSignal WordPress 플러그인 설정","href":"/docs/ko/wordpress"},{"title":"WordPress 문제 해결","href":"/docs/ko/troubleshooting-wordpress-web-push"}]},{"group":"푸시 기능","pages":[{"title":"알림 아이콘","href":"/docs/ko/notification-icons"},{"title":"알림 이미지 및 리치 미디어","href":"/docs/ko/rich-media"},{"title":"알림 사운드","href":"/docs/ko/notification-sounds"},{"title":"알림 배지","href":"/docs/ko/badges"},{"title":"푸시 알림용 액션 버튼","href":"/docs/ko/action-buttons"},{"title":"푸시 빈도 제한","href":"/docs/ko/frequency-capping"},{"title":"푸시 제한","href":"/docs/ko/throttling"},{"title":"iOS: 집중 모드 및 중단 수준","href":"/docs/ko/ios-focus-modes-and-interruption-levels"},{"title":"iOS: 관련성 점수","href":"/docs/ko/ios-relevance-score"}]},{"group":"푸시 분석 \u0026 문제 해결","pages":[{"title":"푸시 메시지 리포트","href":"/docs/ko/push-notification-message-reports"},{"title":"확인된 전달","href":"/docs/ko/confirmed-delivery"},{"title":"알림 CTR","href":"/docs/ko/notification-ctr"},{"title":"모바일 푸시: 알림이 표시되지 않거나 지연됨","href":"/docs/ko/notifications-show-successful-but-are-not-being-shown"},{"title":"Web push: 알림이 표시되지 않음","href":"/docs/ko/notifications-not-shown-web-push"},{"title":"알림 이미지가 표시되지 않음","href":"/docs/ko/notification-images-not-showing"},{"title":"중복 알림","href":"/docs/ko/duplicated-notifications"},{"title":"FCM 만료 토큰 FAQ","href":"/docs/ko/fcm-expired-token-faq"}]}]},{"group":"인앱 메시지","pages":[{"title":"인앱 개요","href":"/docs/ko/in-app-messages-setup"},{"title":"인앱 트리거","href":"/docs/ko/iam-triggers"},{"title":"인앱 클릭 작업","href":"/docs/ko/iam-click-actions"},{"group":"인앱 디자인","pages":[{"title":"드래그 앤 드롭으로 인앱 메시지 디자인하기","href":"/docs/ko/design-your-in-app-message"},{"title":"HTML로 인앱 메시지 디자인하기","href":"/docs/ko/design-your-in-app-message-with-html"},{"title":"인앱 메시지 템플릿 및 퀵스타트","href":"/docs/ko/in-app-html-templates"},{"title":"인앱 메시지 JavaScript API 레퍼런스","href":"/docs/ko/in-app-message-api"}]},{"title":"인앱 메시지 보고서","href":"/docs/ko/in-app-message-reports"},{"title":"인앱 문제 해결","href":"/docs/ko/in-app-message-troubleshooting"}]},{"group":"이메일","pages":[{"title":"이메일 개요","href":"/docs/ko/email-messaging"},{"group":"Email setup","pages":[{"title":"이메일 설정","href":"/docs/ko/email-setup"},{"title":"이메일 DNS 구성","href":"/docs/ko/email-dns-configuration"},{"title":"발신자","href":"/docs/ko/senders"},{"title":"트랜잭션 이메일","href":"/docs/ko/setup-transactional-emails"},{"title":"사용자 지정 이메일 수신 거부 페이지 만들기","href":"/docs/ko/create-custom-unsubscribe-page"}]},{"group":"이메일 전달 가능성","pages":[{"title":"이메일 메시지 보고서","href":"/docs/ko/email-message-reports"},{"title":"이메일 전달 가능성","href":"/docs/ko/email-deliverability"},{"title":"이메일 평판 모범 사례","href":"/docs/ko/email-reputation-best-practices"},{"title":"이메일 주소 유효성 검사","href":"/docs/ko/email-address-validation"},{"title":"이메일 준비 가이드","href":"/docs/ko/email-warm-up"},{"title":"Google Postmaster Tools","href":"/docs/ko/google-postmaster-tools"},{"title":"차단 목록","href":"/docs/ko/suppressions"},{"title":"이메일 문제 해결","href":"/docs/ko/email-troubleshooting"}]},{"group":"이메일 메시지","pages":[{"title":"드래그 앤 드롭으로 이메일 디자인하기","href":"/docs/ko/design-emails-with-drag-and-drop"},{"title":"HTML로 이메일 디자인하기","href":"/docs/ko/design-emails-with-html"},{"title":"이메일 구독 취소 링크 및 헤더","href":"/docs/ko/unsubscribe-links-email-subscriptions"},{"title":"이메일 템플릿 전달","href":"/docs/ko/email-template-forwarding"}]}]},{"group":"SMS 및 RCS","pages":[{"title":"SMS, MMS, RCS 개요","href":"/docs/ko/sms-messaging"},{"title":"Rich Communication Services (RCS)","href":"/docs/ko/rcs-messaging"},{"group":"SMS 설정","pages":[{"title":"SMS 설정","href":"/docs/ko/sms-setup"},{"title":"발신자 리소스 신청 및 국가별 요구사항","sidebarTitle":"발신자 리소스 신청","href":"/docs/ko/sms-registration-requirements"},{"title":"SMS 옵트인 및 수집","href":"/docs/ko/sms-opt-in-and-collection"},{"title":"SMS 동의 키워드 관리","href":"/docs/ko/sms-consent-keyword-management"},{"title":"SMS 키워드","href":"/docs/ko/keywords"}]},{"group":"SMS 메시지","pages":[{"title":"SMS 메시지 리포트","href":"/docs/ko/sms-message-reports"},{"title":"일회용 비밀번호(OTP)","sidebarTitle":"일회용 비밀번호","href":"/docs/ko/sms-verify"}]}]},{"group":"실시간 현황","pages":[{"title":"Live Activities","href":"/docs/ko/live-activities"},{"title":"Live Activities 분석","href":"/docs/ko/live-activities-analytics"}]},{"group":"기능","pages":[{"title":"A/B 테스팅","href":"/docs/ko/ab-testing"},{"title":"다국어 메시징","href":"/docs/ko/multi-language-messaging"},{"group":"메시지 개인화","pages":[{"title":"개인화","href":"/docs/ko/message-personalization"},{"title":"Liquid 구문 사용","href":"/docs/ko/using-liquid-syntax"},{"title":"데이터 피드","href":"/docs/ko/data-feeds"},{"title":"Custom Events로 개인화하기","href":"/docs/ko/personalization-custom-event"},{"title":"속성을 사용한 개인화","href":"/docs/ko/personalization-properties-and-tags"},{"title":"API custom_data로 메시지 개인화하기","href":"/docs/ko/personalization-api-custom-data"},{"title":"CSV를 사용한 동적 콘텐츠","href":"/docs/ko/dynamic-content"}]},{"group":"URL, 링크, 딥 링크","pages":[{"title":"URL, 링크 및 딥 링크","href":"/docs/ko/links"},{"title":"딥 링킹","href":"/docs/ko/deep-linking"},{"title":"이메일 구독 취소 링크 및 헤더","href":"/docs/ko/unsubscribe-links-email-subscriptions"}]},{"title":"리타겟팅 메시지","href":"/docs/ko/retargeting"},{"title":"템플릿","href":"/docs/ko/templates"},{"title":"레이블","href":"/docs/ko/labels"}]}]},{"group":"Journeys","pages":[{"title":"Journey 개요","href":"/docs/ko/journeys-overview"},{"group":"Journey 기능","pages":[{"title":"Journey 설정","href":"/docs/ko/journeys-settings"},{"title":"Journey 메시지","href":"/docs/ko/journeys-messages"},{"title":"Journey 액션","href":"/docs/ko/journeys-actions"},{"title":"Journey Webhook","href":"/docs/ko/journeys-webhook"},{"title":"Journey Webhook을 통해 WhatsApp 메시지 보내기","href":"/docs/ko/sending-whatsapp-messages-via-journey-webhooks"},{"title":"Journeys 관리","href":"/docs/ko/managing-journeys"},{"title":"Journey 분석","href":"/docs/ko/journeys-analytics"}]},{"title":"Journey 예시","href":"/docs/ko/journeys-examples"}]},{"group":"오디언스 \u0026 사용자 지정 이벤트","pages":[{"title":"세그먼트","href":"/docs/ko/segmentation"},{"group":"Users \u0026 Subscriptions","pages":[{"title":"사용자","href":"/docs/ko/users"},{"title":"구독","href":"/docs/ko/subscriptions"},{"title":"별칭","href":"/docs/ko/aliases"},{"title":"테스트 사용자","href":"/docs/ko/test-users"},{"title":"사용자 삭제","href":"/docs/ko/delete-users"}]},{"group":"사용자 지정 이벤트","pages":[{"title":"사용자 지정 이벤트","href":"/docs/ko/custom-events"},{"title":"사용자 지정 이벤트 저장 및 보존","href":"/docs/ko/custom-event-storage"}]},{"group":"태그","pages":[{"title":"태그","href":"/docs/ko/add-user-data-tags"},{"title":"태그: 시간 연산자","href":"/docs/ko/time-operators"}]},{"title":"가져오기","href":"/docs/ko/import"}]},{"group":"분석 \u0026 통합","pages":[{"group":"분석","pages":[{"title":"분석 개요","href":"/docs/ko/analytics-overview"},{"title":"목표","sidebarTitle":"목표","href":"/docs/ko/goals"},{"title":"템플릿 분석","href":"/docs/ko/template-analytics"},{"title":"데이터 내보내기","href":"/docs/ko/exporting-data"},{"title":"사용자 지정 Outcomes","href":"/docs/ko/custom-outcomes"},{"title":"전환 지표","href":"/docs/ko/conversion-metrics"},{"title":"참여 트렌드","href":"/docs/ko/engagement-analytics"},{"title":"구독 트렌드","href":"/docs/ko/subscription-trends"},{"group":"리텐션 지표","pages":[{"title":"리텐션 지표","href":"/docs/ko/retention-metrics"},{"title":"리텐션 곡선 해석","href":"/docs/ko/interpreting-retention-curves"}]},{"title":"지표 용어집","href":"/docs/ko/analytics-metrics-glossary"}]},{"group":"이벤트 스트림","pages":[{"title":"이벤트 스트림","href":"/docs/ko/event-streams"},{"title":"이벤트 스트림 데이터 참조","sidebarTitle":"이벤트 스트림 데이터","href":"/docs/ko/event-streams-data"},{"title":"인앱 메시지 이벤트 스트림","href":"/docs/ko/iam-event-streams"},{"title":"Event Streams와 Google Sheets 통합","href":"/docs/ko/google-sheets-integration-with-event-streams"}]},{"group":"통합","pages":[{"title":"통합 개요","href":"/docs/ko/integrations"},{"title":"데이터 웨어하우스, DMP 및 CRM 통합","href":"/docs/ko/database-dmp-crm-integration"},{"group":"OneSignal을 데이터 소스로 사용","pages":[{"title":"Amplitude","href":"/docs/ko/amplitude"},{"title":"Databricks","description":"OneSignal 메시지 이벤트를 Databricks로 내보내고 Databricks 행동 이벤트를 OneSignal로 가져와서 Journeys를 트리거하고 메시징을 개인화합니다.","href":"/docs/ko/databricks"},{"title":"Google BigQuery","href":"/docs/ko/bigquery"},{"title":"Mixpanel","description":"행동 기반 Cohort를 동기화하고, 메시지 이벤트를 추적하며, 푸시, 이메일, SMS, In-App 채널 전반에서 사용자를 타겟팅하기 위해 OneSignal과 Mixpanel을 통합하세요.","href":"/docs/ko/mixpanel"},{"title":"Snowflake","href":"/docs/ko/snowflake"},{"title":"Segment (Twilio)","href":"/docs/ko/segment-onesignal-integration"}]},{"group":"OneSignal을 데이터 목적지로 사용","pages":[{"title":"Adobe Audience Manager","href":"/docs/ko/adobe-audience-manager"},{"title":"AlloyDB","href":"/docs/ko/alloydb"},{"title":"Amazon Athena","href":"/docs/ko/amazon-athena"},{"title":"Amazon S3","href":"/docs/ko/s3"},{"title":"Amplitude","href":"/docs/ko/amplitude"},{"title":"Apache Kafka","href":"/docs/ko/kafka"},{"title":"Amazon Redshift","href":"/docs/ko/amazon-redshift"},{"title":"Azure Synapse","href":"/docs/ko/azure-synapse"},{"title":"ClickHouse","href":"/docs/ko/clickhouse"},{"title":"Confluent Cloud","href":"/docs/ko/confluent-cloud"},{"title":"Databricks","href":"/docs/ko/databricks"},{"title":"Elasticsearch","description":"Elasticsearch에서 OneSignal로 사용자 지정 이벤트를 동기화하여 사용자 행동을 기반으로 자동화된 Journeys 및 개인화된 메시징 캠페인을 트리거하세요.","href":"/docs/ko/elasticsearch"},{"title":"Google BigQuery","href":"/docs/ko/bigquery"},{"title":"Google Cloud SQL","description":"Google Cloud SQL에서 OneSignal로 사용자 지정 이벤트를 동기화하여 사용자 행동을 기반으로 자동화된 저니와 개인화된 메시징 캠페인을 트리거하세요.","href":"/docs/ko/google-cloud-sql"},{"title":"Google Sheets","href":"/docs/ko/google-sheets"},{"title":"Greenplum","href":"/docs/ko/greenplum"},{"title":"HubSpot","href":"/docs/ko/hubspot"},{"title":"Materialize","href":"/docs/ko/materialize"},{"title":"Microsoft Fabric","href":"/docs/ko/microsoft-fabric"},{"title":"Mixpanel","href":"/docs/ko/mixpanel"},{"title":"MotherDuck","href":"/docs/ko/motherduck"},{"title":"MySQL","href":"/docs/ko/mysql"},{"title":"PostgreSQL","href":"/docs/ko/postgresql"},{"title":"Pub/Sub","href":"/docs/ko/google-pubsub"},{"title":"SingleStore","href":"/docs/ko/singlestore"},{"title":"Snowflake","href":"/docs/ko/snowflake"},{"title":"SQL Server","href":"/docs/ko/sql-server"},{"title":"Starburst Enterprise","href":"/docs/ko/starburst-enterprise"},{"title":"Starburst Galaxy","href":"/docs/ko/starburst-galaxy"},{"title":"Trino","href":"/docs/ko/trino"},{"title":"Segment (Twilio)","href":"/docs/ko/segment-onesignal-integration"}]},{"group":"소비자 추적","pages":[{"title":"RevenueCat","href":"/docs/ko/revenuecat"},{"title":"Adjust","href":"/docs/ko/adjust"},{"title":"BlueConic","href":"/docs/ko/blueconic"}]},{"title":"OneSignal과 통합 구축: 파트너 가이드","href":"/docs/ko/building-an-integration-with-onesignal-partner-guide"}]}]},{"group":"개인 정보 보호 \u0026 보안","pages":[{"group":"보안 자격 증명","pages":[{"title":"SOC 2 Type II","href":"/docs/ko/soc-2-type-ii"},{"title":"ISO 27001","href":"/docs/ko/iso27001"},{"title":"HIPAA","href":"/docs/ko/hipaa"}]},{"group":"데이터 개인 정보 보호 \u0026 규정 준수","pages":[{"title":"GDPR 및 개인 권리","href":"/docs/ko/gdpr-compliance"},{"title":"EU-US 데이터 개인 정보 보호 프레임워크","href":"/docs/ko/eu-us-data-privacy-framework"},{"title":"이메일 규정 준수","href":"/docs/ko/email-compliance"},{"title":"SMS 규제 준수","href":"/docs/ko/sms-regulatory-compliance"},{"title":"Apple 앱 개인정보 보호 요구 사항","href":"/docs/ko/apple-app-privacy-requirements"},{"title":"Google Play 데이터 보안 요구 사항","href":"/docs/ko/google-play-data-safety-requirements"},{"title":"데이터 수집 및 보안 FAQ","href":"/docs/ko/data-questions"},{"title":"OneSignal SDK가 수집하는 데이터","href":"/docs/ko/data-collected-by-the-onesignal-sdk"},{"title":"개인 데이터 처리","href":"/docs/ko/handling-personal-data"}]},{"group":"인증 및 보안","pages":[{"title":"2단계 인증","href":"/docs/ko/2-step-authentication"},{"title":"Single Sign-On (SSO)","href":"/docs/ko/sso"}]}]}]},{"tab":"개발자 가이드","pages":[{"title":"개발자 가이드","href":"/docs/ko/developers"}]},{"tab":"튜토리얼","pages":[{"title":"튜토리얼","href":"/docs/ko/tutorials"}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/reference/rest-api-overview"}]},{"tab":"Release Notes","pages":[{"title":"Release Notes","href":"/release-notes/changelog"}]}],"global":{"anchors":[{"anchor":"Blog","icon":"newspaper","href":"https://onesignal.com/blog"},{"anchor":"GitHub","icon":"github","href":"https://github.com/OneSignal"},{"anchor":"YouTube","icon":"youtube","href":"https://www.youtube.com/@onesignalofficial/playlists"}]}},{"language":"ja","pages":[{"title":"ja","href":"/docs/ja/bigquery"}]},{"language":"tr","pages":[{"title":"tr","href":"/docs/tr/bigquery"}]},{"language":"pt-BR","pages":[{"title":"pt-BR","href":"/docs/pt-BR/bigquery"}]},{"language":"es","pages":[{"title":"es","href":"/docs/es/bigquery"}]},{"language":"fr","pages":[{"title":"fr","href":"/docs/fr/bigquery"}]}]},"basePath":"","title":"Google BigQuery - OneSignal Documentation","buildId":"dpl_596ePT575z4qnAFksq1biRW97aLY","deploymentId":"dpl_596ePT575z4qnAFksq1biRW97aLY","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-BXrZabKK.js","DynamicMarkdown-CtasenyM.js","zoom-image-lightbox-C5F0mVLH.js","lightbox-handle-r17bVUz3.js"]}
