Langsung ke konten utama
Area teknologi
close
AI dan ML
Pengembangan aplikasi
Hosting aplikasi
Compute
Pipeline dan analisis data
Database
Terdistribusi, hybrid, dan multicloud
Solusi industri
Migrasi
Jaringan
Kemampuan observasi dan pemantauan
Keamanan
Storage
Alat cross product
close
Pengelolaan akses dan resource
Pengelolaan biaya dan penggunaan
Infrastruktur sebagai kode
SDK, bahasa, framework, dan alat
/
Konsol
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
עברית
中文 – 简体
中文 – 繁體
日本語
한국어
Masuk
BigQuery
Mulai gratis
Ringkasan
Panduan
Referensi
Contoh
Referensi
Area teknologi
Lainnya
Ringkasan
Panduan
Referensi
Contoh
Referensi
Alat cross product
Lainnya
Konsol
Kuota dan batas
Referensi kuota dan batas
Memecahkan masalah error kuota dan batas
Alat command line BigQuery
Referensi alat command line bq
SQL di BigQuery
Referensi GoogleSQL
Sintaksis kueri
Sintaksis pipa
Referensi umum
Jenis data
Struktur dan sintaksis leksikal
Aturan konversi
Elemen format
Kolasi
Analisis teks
Persamaan
Panggilan fungsi
Panggilan fungsi agregat
Panggilan fungsi jendela
Operator
Ekspresi bersyarat
Subkueri
Fungsi
Semua fungsi
Fungsi enkripsi AEAD
Ringkasan
AEAD.DECRYPT_BYTES
AEAD.DECRYPT_STRING
AEAD.ENCRYPT
DETERMINISTIC_DECRYPT_BYTES
DETERMINISTIC_DECRYPT_STRING
DETERMINISTIC_ENCRYPT
KEYS.ADD_KEY_FROM_RAW_BYTES
KEYS.KEYSET_CHAIN
KEYS.KEYSET_FROM_JSON
KEYS.KEYSET_LENGTH
KEYS.KEYSET_TO_JSON
KEYS.NEW_KEYSET
KEYS.NEW_WRAPPED_KEYSET
KEYS.REWRAP_KEYSET
KEYS.ROTATE_KEYSET
KEYS.ROTATE_WRAPPED_KEYSET
Fungsi agregat
Ringkasan
AGG
ANY_VALUE
ARRAY_AGG
ARRAY_CONCAT_AGG
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNTIF
PENGELOMPOKAN
LOGICAL_AND
LOGICAL_OR
MAKS
MAX_BY
MIN
MIN_BY
STRING_AGG
SUM
Fungsi perkiraan agregat
Ringkasan
APPROX_COUNT_DISTINCT
APPROX_QUANTILES
APPROX_TOP_COUNT
APPROX_TOP_SUM
Fungsi array
Ringkasan
ARRAY
ARRAY_CONCAT
ARRAY_FIRST
ARRAY_LAST
ARRAY_LENGTH
ARRAY_REVERSE
ARRAY_SLICE
ARRAY_TO_STRING
GENERATE_ARRAY
GENERATE_DATE_ARRAY
GENERATE_TIMESTAMP_ARRAY
Fungsi bit
Ringkasan
BIT_COUNT
Fungsi konversi
Ringkasan
CAST
PARSE_BIGNUMERIC
PARSE_NUMERIC
SAFE_CAST
Fungsi tanggal
Ringkasan
CURRENT_DATE
DATE
DATE_ADD
DATE_DIFF
DATE_FROM_UNIX_DATE
DATE_SUB
DATE_TRUNC
EXTRACT (date)
FORMAT_DATE
LAST_DAY (tanggal)
PARSE_DATE
UNIX_DATE
Fungsi tanggal dan waktu
Ringkasan
CURRENT_DATETIME
DATETIME
DATETIME_ADD
DATETIME_DIFF
DATETIME_SUB
DATETIME_TRUNC
EXTRACT (datetime)
FORMAT_DATETIME
LAST_DAY (datetime)
PARSE_DATETIME
Fungsi proses debug
Ringkasan
KESALAHAN
Fungsi agregat pribadi diferensial
Ringkasan
AVG (DIFFERENTIAL_PRIVACY)
COUNT (DIFFERENTIAL_PRIVACY)
PERCENTILE_CONT (DIFFERENTIAL_PRIVACY)
SUM (DIFFERENTIAL_PRIVACY)
Fungsi kueri gabungan
Ringkasan
EXTERNAL_QUERY
Fungsi enkripsi DLP
Ringkasan
DLP_DETERMINISTIC_ENCRYPT
DLP_DETERMINISTIC_DECRYPT
DLP_KEY_CHAIN
Fungsi geografi
Ringkasan
ST_ANGLE
ST_AREA
ST_ASBINARY
ST_ASGEOJSON
ST_ASTEXT
ST_AZIMUTH
ST_BOUNDARY
ST_BOUNDINGBOX
ST_BUFFER
ST_BUFFERWITHTOLERANCE
ST_CENTROID
ST_CENTROID_AGG
ST_CLOSESTPOINT
ST_CLUSTERDBSCAN
ST_CONTAINS
ST_CONVEXHULL
ST_COVEREDBY
ST_COVERS
ST_DIFFERENCE
ST_DIMENSION
ST_DISJOINT
ST_DISTANCE
ST_DUMP
ST_DWITHIN
ST_ENDPOINT
ST_EQUALS
ST_EXTENT
ST_EXTERIORRING
ST_GEOGFROM
ST_GEOGFROMGEOJSON
ST_GEOGFROMTEXT
ST_GEOGFROMWKB
ST_GEOGPOINT
ST_GEOGPOINTFROMGEOHASH
ST_GEOHASH
ST_GEOMETRYTYPE
ST_HAUSDORFFDISTANCE
ST_HAUSDORFFDWITHIN
ST_INTERIORRINGS
ST_INTERSECTION
ST_INTERSECTS
ST_INTERSECTSBOX
ST_ISCLOSED
ST_ISCOLLECTION
ST_ISEMPTY
ST_ISRING
ST_LENGTH
ST_LINEINTERPOLATEPOINT
ST_LINELOCATEPOINT
ST_LINESUBSTRING
ST_MAKELINE
ST_MAKEPOLYGON
ST_MAKEPOLYGONORIENTED
ST_MAXDISTANCE
ST_NPOINTS
ST_NUMGEOMETRIES
ST_NUMPOINTS
ST_PERIMETER
ST_POINTN
ST_REGIONSTATS
ST_SIMPLIFY
ST_SNAPTOGRID
ST_STARTPOINT
ST_TOUCHES
ST_UNION
ST_UNION_AGG
ST_WITHIN
ST_X
ST_Y
S2_CELLIDFROMPOINT
S2_COVERINGCELLIDS
Fungsi hash
Ringkasan
FARM_FINGERPRINT
MD5
SHA1
SHA256
SHA512
Fungsi HyperLogLog++
Ringkasan
HLL_COUNT.EXTRACT
HLL_COUNT.INIT
HLL_COUNT.MERGE
HLL_COUNT.MERGE_PARTIAL
Fungsi interval
Ringkasan
EXTRACT (interval)
JUSTIFY_DAYS
JUSTIFY_HOURS
JUSTIFY_INTERVAL
MAKE_INTERVAL
Fungsi JSON
Ringkasan
BOOL
FLOAT64
INT64
JSON_ARRAY
JSON_ARRAY_APPEND
JSON_ARRAY_INSERT
JSON_EXTRACT
JSON_EXTRACT_ARRAY
JSON_EXTRACT_SCALAR
JSON_EXTRACT_STRING_ARRAY
JSON_FLATTEN
JSON_KEYS
JSON_OBJECT
JSON_QUERY
JSON_QUERY_ARRAY
JSON_REMOVE
JSON_SET
JSON_STRIP_NULLS
JSON_TYPE
JSON_VALUE
JSON_VALUE_ARRAY
LAX_BOOL
LAX_FLOAT64
LAX_INT64
LAX_STRING
PARSE_JSON
STRING (JSON)
TO_JSON
TO_JSON_STRING
Fungsi KLL
Ringkasan
KLL_QUANTILES.EXTRACT_INT64
KLL_QUANTILES.EXTRACT_FLOAT64
KLL_QUANTILES.EXTRACT_POINT_INT64
KLL_QUANTILES.EXTRACT_POINT_FLOAT64
KLL_QUANTILES.INIT_INT64
KLL_QUANTILES.INIT_FLOAT64
KLL_QUANTILES.MERGE_INT64
KLL_QUANTILES.MERGE_FLOAT64
KLL_QUANTILES.MERGE_PARTIAL
KLL_QUANTILES.MERGE_POINT_INT64
KLL_QUANTILES.MERGE_POINT_FLOAT64
Fungsi matematika
Ringkasan
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CBRT
CEIL
CEILING
COS
COSH
COSINE_DISTANCE
COT
COTH
CSC
CSCH
DIV
EXP
EUCLIDEAN_DISTANCE
FLOOR
TERBAIK
IS_INF
IS_NAN
PALING SEDIKIT
LN
LOG
LOG10
MOD
POW
DAYA
RAND
RANGE
RANGE_BUCKET
ROUND
SAFE_ADD
SAFE_DIVIDE
SAFE_MULTIPLY
SAFE_NEGATE
SAFE_SUBTRACT
SEC
SECH
TANDA
SIN
SINH
SQRT
TAN
TANH
TRUNC
Fungsi navigasi
Ringkasan
FIRST_VALUE
LAG
LAST_VALUE
MEMIMPIN
NTH_VALUE
PERCENTILE_CONT
PERCENTILE_DISC
Fungsi net
Ringkasan
NET.HOST
NET.IP_FROM_STRING
NET.IP_NET_MASK
NET.IP_TO_STRING
NET.IP_TRUNC
NET.IPV4_FROM_INT64
NET.IPV4_TO_INT64
NET.PUBLIC_SUFFIX
NET.REG_DOMAIN
NET.SAFE_IP_FROM_STRING
Fungsi penomoran
Ringkasan
CUME_DIST
DENSE_RANK
NTILE
PERCENT_RANK
RANK
ROW_NUMBER
Fungsi ObjectRef
Ringkasan
OBJ.FETCH_METADATA
OBJ.GET_ACCESS_URL
OBJ.GET_READ_URL
OBJ.MAKE_REF
Fungsi rentang
Ringkasan
GENERATE_RANGE_ARRAY
RANGE
RANGE_CONTAINS
RANGE_END
RANGE_INTERSECT
RANGE_OVERLAPS
RANGE_SESSIONIZE
RANGE_START
Fungsi penelusuran
Ringkasan
TELUSURI
VECTOR_SEARCH
Fungsi keamanan
Ringkasan
SESSION_USER
Fungsi agregat statistik
Ringkasan
CORR
COVAR_POP
COVAR_SAMP
STDDEV
STDDEV_POP
STDDEV_SAMP
VAR_POP
VAR_SAMP
VARIANCE
Fungsi string
Ringkasan
ASCII
BYTE_LENGTH
CHAR_LENGTH
CHARACTER_LENGTH
CHR
CODE_POINTS_TO_BYTES
CODE_POINTS_TO_STRING
COLLATE
CONCAT
CONTAINS_SUBSTR
EDIT_DISTANCE
ENDS_WITH
FORMAT
FROM_BASE32
FROM_BASE64
FROM_HEX
INITCAP
INSTR
KIRI
LENGTH
LEBIH RENDAH
LPAD
LTRIM
NORMALIZE
NORMALIZE_AND_CASEFOLD
OCTET_LENGTH
REGEXP_CONTAINS
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
ULANGI
GANTI
REVERSE
KANAN
RPAD
RTRIM
SAFE_CONVERT_BYTES_TO_STRING
SOUNDEX
SPLIT
STARTS_WITH
STRPOS
SUBSTR
SUBSTRING
TO_BASE32
TO_BASE64
TO_CODE_POINTS
TO_HEX
TERJEMAHKAN
TRIM
UNICODE
UPPER
Fungsi tabel (bawaan)
Ringkasan
EXTERNAL_OBJECT_TRANSFORM
Fungsi analisis teks
Ringkasan
BAG_OF_WORDS
TEXT_ANALYZE
TF_IDF
Fungsi waktu
Ringkasan
CURRENT_TIME
EXTRACT (waktu)
FORMAT_TIME
PARSE_TIME
WAKTU
TIME_ADD
TIME_DIFF
TIME_SUB
TIME_TRUNC
Fungsi deret waktu
Ringkasan
APPENDS
PERUBAHAN
DATE_BUCKET
DATETIME_BUCKET
GAP_FILL
TIMESTAMP_BUCKET
Fungsi stempel waktu
Ringkasan
CURRENT_TIMESTAMP
EXTRACT (stempel waktu)
FORMAT_TIMESTAMP
PARSE_TIMESTAMP
STRING (stempel waktu)
TIMESTAMP
TIMESTAMP_ADD
TIMESTAMP_DIFF
TIMESTAMP_MICROS
TIMESTAMP_MILLIS
TIMESTAMP_SECONDS
TIMESTAMP_SUB
TIMESTAMP_TRUNC
UNIX_MICROS
UNIX_MILLIS
UNIX_SECONDS
Fungsi utilitas
Ringkasan
GENERATE_UUID
TYPEOF
Fungsi indeks vektor
Ringkasan
VECTOR_INDEX.STATISTICS
Fungsi jendela
Pernyataan
Bahasa definisi data (DDL)
Bahasa manipulasi data (DML)
Bahasa kontrol data (DCL)
Bahasa prosedur
Mengekspor pernyataan
Memuat pernyataan
Pernyataan proses debug
Referensi BigQuery ML SQL
Membuat dan melatih model
Ringkasan pernyataan CREATE MODEL
Regresi dan klasifikasi
Regresi logistik dan linear
Pohon yang diperkuat
Hutan acak (random forest)
Jaringan neural dalam.
Jaringan wide-and-deep
Model AutoML
Dukungan
K-means
Pengurangan dimensi
Analisis komponen utama
Autoencoder
Rekomendasi
Pemfaktoran matriks
Analisis yang diperkaya
Perkiraan univariat dengan model ARIMA_PLUS
Perkiraan multivariat dengan model ARIMA_PLUS_XREG
Analisis kontribusi
Mengimpor model
Open Neural Network Exchange (ONNX)
TensorFlow
TensorFlow Lite
XGBoost
Model jarak jauh
Model dasar
LLM Agent Platform sebagai MaaS
Model embedding Agent Platform sebagai MaaS
Model terbuka yang di-deploy sendiri
Model Gemini yang di-fine-tune
Layanan Cloud AI
Model kustom yang di-deploy ke Agent Platform
Khusus transformasi
Rekayasa fitur
ML.TRANSFORM
ML.FEATURE_INFO
Fungsi umum
ML.IMPUTER
Fungsi numerik
ML.BUCKETIZE
ML.MAX_ABS_SCALER
ML.MIN_MAX_SCALER
ML.NORMALIZER
ML.POLYNOMIAL_EXPAND
ML.QUANTILE_BUCKETIZE
ML.ROBUST_SCALER
ML.STANDARD_SCALER
Fungsi kategoris
ML.FEATURE_CROSS
ML.HASH_BUCKETIZE
ML.LABEL_ENCODER
ML.MULTI_HOT_ENCODER
ML.ONE_HOT_ENCODER
Fungsi teks
ML.NGRAMS
ML.BAG_OF_WORDS
ML.TF_IDF
Fungsi gambar
ML.CONVERT_COLOR_SPACE
ML.CONVERT_IMAGE_TYPE
ML.DECODE_IMAGE
ML.RESIZE_IMAGE
Fungsi pencarian point-in-time
ML.FEATURES_AT_TIME
ML.ENTITY_FEATURES_AT_TIME
Analisis yang diperkaya
AI.FORECAST
AI.DETECT_ANOMALIES
AI.KEY_DRIVERS
ML.SEASONALITY
ML.TREND
ML.CORRELATION
AI.EVALUATE
ML.GET_INSIGHTS
ML.DETECT_CHANGE_POINTS
Fungsi penyesuaian hyperparameter
ML.TRIAL_INFO
Fungsi evaluasi
ML.EVALUATE
ML.ROC_CURVE
ML.CONFUSION_MATRIX
ML.ARIMA_EVALUATE
ML.TRAINING_INFO
ML.RECONSTRUCTION_LOSS
ML.HOLIDAY_INFO
Fungsi inferensi
ML.PREDICT
ML.FORECAST
ML.RECOMMEND
ML.DETECT_ANOMALIES
Fungsi AI generatif
Tujuan umum
AI.GENERATE
AI.GENERATE_BOOL
AI.GENERATE_DOUBLE
AI.GENERATE_INT
AI.GENERATE_TABLE
AI.GENERATE_TEXT
ML.GENERATE_TEXT
Terkelola
AI.IF
AI.SCORE
AI.CLASSIFY
AI.AGG
Pembuatan embedding dan penelusuran semantik
AI.EMBED
AI.SIMILARITY
AI.SEARCH
VECTOR_SEARCH
AI.GENERATE_EMBEDDING
ML.GENERATE_EMBEDDING
Fungsi utilitas AI
AI.COUNT_TOKENS
Fungsi AI Cloud API
ML.UNDERSTAND_TEXT
ML.TRANSLATE
ML.PROCESS_DOCUMENT
ML.TRANSCRIBE
ML.ANNOTATE_IMAGE
Fungsi AI Explanations
ML.EXPLAIN_PREDICT
ML.EXPLAIN_FORECAST
ML.GLOBAL_EXPLAIN
ML.FEATURE_IMPORTANCE
ML.ADVANCED_WEIGHTS
Fungsi bobot model
ML.WEIGHTS
ML.CENTROIDS
ML.PRINCIPAL_COMPONENTS
ML.PRINCIPAL_COMPONENT_INFO
ML.ARIMA_COEFFICIENTS
Fungsi pemantauan model
ML.DESCRIBE_DATA
ML.VALIDATE_DATA_DRIFT
ML.VALIDATE_DATA_SKEW
ML.TFDV_DESCRIBE
ML.TFDV_VALIDATE
Fungsi utilitas matematika
ML.DISTANCE
ML.LP_NORM
Pernyataan pengelolaan model
Pernyataan EXPORT MODEL
Pernyataan ALTER MODEL
Pernyataan DROP MODEL
Tampilan INFORMATION SCHEMA
Pengantar
Kontrol akses
Tabel Virtual OBJECT_PRIVILEGES
BI Engine
BI_CAPACITIES
BI_CAPACITY_CHANGES
Konfigurasi
Tabel virtual EFFECTIVE_PROJECT_OPTIONS
Tampilan ORGANIZATION_OPTIONS
Tampilan ORGANIZATION_OPTIONS_CHANGES
Tabel virtual PROJECT_OPTIONS
Tampilan PROJECT_OPTIONS_CHANGES
Set data
Tampilan SCHEMATA
Tampilan SCHEMATA_LINKS
Tampilan SCHEMATA_OPTIONS
Tampilan SHARED_DATASET_USAGE
Tabel virtual SCHEMATA_REPLICAS
Tampilan SCHEMATA_REPLICAS_BY_FAILOVER_RESERVATION
Grafik
Tampilan PROPERTY_GRAPHS
Tugas
Tampilan JOBS
Tampilan JOBS_BY_USER
Tampilan JOBS_BY_FOLDER
Tampilan JOBS_BY_ORGANIZATION
Tugas menurut timeslice
Tampilan JOBS_TIMELINE
Tabel Virtual JOBS_TIMELINE_BY_USER
Tabel virtual JOBS_TIMELINE_BY_FOLDER
Tampilan JOBS_TIMELINE_BY_ORGANIZATION
Rekomendasi dan insight
Tampilan INSIGHTS
Tampilan REKOMENDASI
Tampilan RECOMMENDATIONS_BY_ORGANIZATION
Pemesanan
Tampilan ASSIGNMENTS
Tampilan ASSIGNMENT_CHANGES
Tampilan CAPACITY_COMMITMENTS
Tampilan CAPACITY_COMMITMENT_CHANGES
Tabel Virtual RESERVATIONS
Tampilan RESERVATION_CHANGES
Tampilan RESERVATIONS_TIMELINE
Rutinitas
Tampilan PARAMETERS
Tampilan ROUTINES
Tampilan ROUTINE_OPTIONS
Indeks penelusuran
Tampilan SEARCH_INDEXES
Tampilan SEARCH_INDEX_COLUMNS
Tampilan SEARCH_INDEX_COLUMN_OPTIONS
Tampilan SEARCH_INDEX_OPTIONS
Tampilan SEARCH_INDEXES_BY_ORGANIZATION
Sesi
Tampilan SESSIONS_BY_PROJECT
Tampilan SESSIONS_BY_USER
Tabel
Tampilan COLUMNS
Tabel virtual COLUMN_FIELD_PATHS
Tampilan CONSTRAINT_COLUMN_USAGE
Tampilan KEY_COLUMN_USAGE
Tampilan PARTITIONS
Tampilan TABLES
Tabel Virtual TABLE_OPTIONS
Tampilan TABLE_CONSTRAINTS
Tampilan TABLE_SNAPSHOTS
Tampilan TABLE_STORAGE
Tampilan TABLE_STORAGE_BY_FOLDER
Tampilan TABLE_STORAGE_BY_ORGANIZATION
Tampilan TABLE_STORAGE_USAGE_TIMELINE
Tampilan TABLE_STORAGE_USAGE_TIMELINE_BY_FOLDER
Tampilan TABLE_STORAGE_USAGE_TIMELINE_BY_ORGANIZATION
Storage Write API (gRPC)
Tampilan WRITE_API_TIMELINE
Tampilan WRITE_API_TIMELINE_BY_FOLDER
Tampilan WRITE_API_TIMELINE_BY_ORGANIZATION
Storage Write API (REST)
Tampilan STREAMING_TIMELINE
Tampilan STREAMING_TIMELINE_BY_FOLDER
Tampilan STREAMING_TIMELINE_BY_ORGANIZATION
Indeks vektor
Tampilan VECTOR_INDEXES
Tampilan VECTOR_INDEX_COLUMNS
Tampilan VECTOR_INDEX_OPTIONS
Penayangan
Tampilan VIEWS
Tampilan MATERIALIZED_VIEWS
Referensi legacy SQL
Ketersediaan fitur Legacy SQL
Bermigrasi ke GoogleSQL
Fungsi dan operator
Jenis data
Membuat kueri untuk kolom bertingkat dan berulang
Fungsi yang ditentukan pengguna (UDF)
Penghias tabel
GQL di BigQuery
Ringkasan
Grafik BigQuery dan standar ISO
Pernyataan skema
Ringkasan
Pernyataan CREATE PROPERTY GRAPH
Pernyataan DROP PROPERTY GRAPH
Pernyataan kueri
Ringkasan
Sintaksis GQL
Klausul grafik
Pernyataan FILTER
Pernyataan FOR
Pernyataan LET
Pernyataan LIMIT
Pernyataan MATCH
Pernyataan NEXT
Pernyataan OFFSET
Pernyataan ORDER BY
Pernyataan RETURN
Pernyataan SKIP
Pernyataan WITH
Grafik dalam SQL
Ringkasan
GRAPH_EXPAND TVF
Operator GRAPH_TABLE
Pola
Ringkasan
Pola grafik
Pola elemen
Pola subjalur
Pola jalur yang dikuantifikasi
Ekspresi label
Awalan penelusuran jalur
Mode jalur
Subkueri
Ringkasan
Subkueri ARRAY
Subkueri EXISTS
Subkueri IN
Subkueri VALUE
Jenis data
Ringkasan
Jenis elemen grafik
Jenis jalur grafik
Operator
Ringkasan
Operator logika
Predikat ALL_DIFFERENT
Predikat IS DESTINATION
Predikat IS SOURCE
Predikat SAME
Fungsi
Ringkasan
Fungsi DESTINATION_NODE_ID
Fungsi EDGES
Fungsi ELEMENT_ID
Fungsi IS_FIRST
Fungsi LABEL
Fungsi NODES
Fungsi PATH_FIRST
Fungsi PATH_LAST
Fungsi PATH_LENGTH
Fungsi SOURCE_NODE_ID
Ekspresi bersyarat
Ringkasan
BigQuery Migration Service
Referensi sumber migrasi
Amazon Redshift
Ringkasan migrasi
Memigrasikan skema dan data Amazon Redshift
Memigrasikan skema dan data Amazon Redshift saat menggunakan VPC
Referensi terjemahan SQL
Apache Hadoop dan Hive
Memigrasikan skema dan data Apache Hive
Mengekstrak metadata dari Apache Hive
Memigrasikan izin dari Hadoop
Menjadwalkan transfer tabel Hive Metastore
Referensi terjemahan Apache Hive SQL
IBM Netezza
Bermigrasi dari IBM Netezza
Referensi terjemahan SQL
Oracle
Panduan migrasi
Referensi terjemahan SQL
Kepingan Salju
Pengantar
Menjadwalkan transfer Snowflake
Deteksi dan pemetaan skema
Mengonfigurasi konektivitas pribadi
Mengonfigurasi kebijakan jaringan untuk transfer Snowflake
Menyiapkan transfer inkremental
Tutorial
Referensi terjemahan SQL
Teradata
Pengantar
Ringkasan migrasi
Memigrasikan skema dan data Teradata
Tutorial migrasi
Referensi terjemahan SQL
Memigrasikan metadata ke tabel katalog REST Iceberg Lakehouse
BigQuery Data Transfer Service
Referensi sumber transfer
Pengantar
Amazon S3
Pengantar
Menjadwalkan transfer
Mentransfer parameter runtime
Azure Blob Storage
Pengantar
Menjadwalkan transfer
Mentransfer parameter runtime
Campaign Manager
Menjadwalkan transfer
Transformasi laporan
Cloud Storage
Pengantar
Menjadwalkan transfer
Mentransfer parameter runtime
Comparison Shopping Service Center
Pengantar
Menjadwalkan transfer
Skema laporan transfer
Display & Video 360
Menjadwalkan transfer
Transformasi laporan
Facebook Ads
Pengantar
Menjadwalkan transfer
Transformasi laporan
Google Ad Manager
Menjadwalkan transfer
Transformasi laporan
Google Ads
Menjadwalkan transfer
Transformasi laporan
Google Analytics 4
Menjadwalkan transfer
Transformasi laporan
Google Merchant Center
Pengantar
Menjadwalkan transfer
Membuat kueri data Anda
Panduan migrasi
Produk terlaris
Daya saing harga
Skema laporan transfer
Tabel Produk Terlaris
Tabel Inventaris Lokal
Tabel performa
Tabel Daya Saing Harga
Tabel Analisis Harga
Tabel Penargetan Produk
Tabel produk
Tabel Inventaris Regional
Google Play
Menjadwalkan transfer
Mentransfer transformasi laporan
Metastore Hive
Menjadwalkan transfer
HubSpot
Menjadwalkan transfer
Klaviyo
Pengantar
Menjadwalkan transfer
Referensi model data
Mailchimp
Menjadwalkan transfer
Microsoft SQL Server
Menjadwalkan transfer
MySQL
Menjadwalkan transfer
Oracle
Pengantar
Menjadwalkan transfer
PayPal
Menjadwalkan transfer
PostgreSQL
Pengantar
Menjadwalkan transfer
Salesforce
Pengantar
Menjadwalkan transfer
Salesforce Marketing Cloud
Menjadwalkan transfer
Search Ads 360
Menjadwalkan transfer
Mentransfer transformasi laporan
Panduan migrasi
ServiceNow
Menjadwalkan transfer
Shopify
Menjadwalkan transfer
Stripe
Menjadwalkan transfer
Channel YouTube
Menjadwalkan transfer
Mentransfer transformasi laporan
Pemilik konten YouTube
Menjadwalkan transfer
Mentransfer transformasi laporan
Python API DataFrames BigQuery
BigQuery DataFrames
BigQuery API
Referensi BigQuery API
Ringkasan BigQuery API dan library
Referensi BigQuery API
Library klien BigQuery
REST API BigQuery
Referensi REST (v2)
Resource REST
datasets
Ringkasan
delete
get
insert
list
patch
undelete
update
tugas
Ringkasan
batal
delete
get
getQueryResults
insert
list
kueri
yang paling canggih
Ringkasan
delete
get
list
patch
project
Ringkasan
getServiceAccount
list
rutinitas
Ringkasan
delete
get
getIamPolicy
insert
list
setIamPolicy
testIamPermissions
update
rowAccessPolicies
Ringkasan
batchDelete
delete
get
getIamPolicy
insert
list
testIamPermissions
update
tabledata
Ringkasan
insertAll
list
tabel
Ringkasan
delete
get
getIamPolicy
insert
list
patch
setIamPolicy
testIamPermissions
update
Types
ConnectionProperty
DataFormatOptions
DatasetAccessEntry
DmlStats
EncryptionConfiguration
ErrorProto
GetPolicyOptions
Tugas
JobCreationReason
JobReference
Kebijakan
ProjectReference
QueryParameter
RoundingMode
SessionInfo
StandardSqlDataType
StandardSqlField
TableReference
TargetType
TestIamPermissionsResponse
UpdateMode
Upload API
Referensi API Kebijakan Data BigQuery
Referensi REST Kebijakan Data
v1
Resource REST
projects.locations.dataPolicies
Ringkasan
create
delete
get
getIamPolicy
list
patch
rename
setIamPolicy
testIamPermissions
v1beta1
Resource REST
projects.locations.dataPolicies
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
v2
Resource REST
projects.locations.dataPolicies
Ringkasan
addGrantees
create
delete
get
getIamPolicy
list
patch
removeGrantees
setIamPolicy
testIamPermissions
v2beta1
Resource REST
projects.locations.dataPolicies
Ringkasan
addGrantees
create
delete
get
getIamPolicy
list
patch
removeGrantees
setIamPolicy
testIamPermissions
Referensi API Koneksi BigQuery
Library klien Koneksi BigQuery
REST API Koneksi BigQuery
Referensi RPC
Ringkasan
google.cloud.bigquery.connection.v1
google.cloud.bigquery.connection.v1beta1
google.iam.v1
google.type
Referensi REST (v1)
Resource REST
projects.locations.connections
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
Referensi REST (v1beta1)
Resource REST
projects.locations.connections
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
updateCredential
Types
AuditConfig
Binding
GetIamPolicyRequest
LogType
Kebijakan
SetIamPolicyRequest
TestIamPermissionsRequest
TestIamPermissionsResponse
Referensi API Migrasi BigQuery
Library klien Migrasi BigQuery
REST API Migrasi BigQuery
Referensi REST (v2)
Resource REST
projects.locations.workflows
Ringkasan
create
delete
get
list
mulai
projects.locations.workflows.subtasks
Ringkasan
get
list
Types
ResourceErrorDetail
TimeSeries
Referensi REST (v2alpha)
Resource REST
projects.locations.workflows
Ringkasan
create
delete
get
list
mulai
projects.locations.workflows.subtasks
Ringkasan
get
list
Types
ResourceErrorDetail
TimeSeries
Types
Distribusi
ErrorInfo
MetricKind
ResourceInfo
ValueType
Referensi RPC
Ringkasan
google.api
google.cloud.bigquery.migration.tasks.assessment.v2alpha
google.cloud.bigquery.migration.tasks.translation.v2alpha
google.cloud.bigquery.migration.v2
google.cloud.bigquery.migration.v2alpha
google.rpc
Referensi BigQuery Storage API
Library klien Storage API
Referensi RPC
Ringkasan
google.cloud.bigquery.storage.v1
google.cloud.bigquery.storage.v1beta1
google.cloud.bigquery.storage.v1beta2
google.rpc
Referensi API BigQuery Reservation
Library klien BigQuery Reservation API
REST API Reservasi BigQuery
Referensi RPC
Ringkasan
google.cloud.bigquery.reservation.v1
google.iam.v1
google.rpc
google.type
Referensi REST (v1)
Resource REST
projects.locations
Ringkasan
getBiReservation
searchAllAssignments
searchAssignments
updateBiReservation
projects.locations.capacityCommitments
Ringkasan
create
delete
get
list
gabungkan
patch
bagian
projects.locations.reservationGroups
Ringkasan
create
delete
get
list
projects.locations.reservations
Ringkasan
create
delete
failoverReservation
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
projects.locations.reservations.assignments
Ringkasan
create
delete
getIamPolicy
list
move
patch
setIamPolicy
testIamPermissions
Types
BiReservation
Edisi
GetPolicyOptions
Kebijakan
Status
TestIamPermissionsResponse
Types
Status
Referensi API BigQuery Analytics Hub
Library klien Analytics Hub
REST API Analytics Hub
Referensi REST (v1)
Resource REST
organizations.locations.dataExchanges
Ringkasan
list
projects.locations.dataExchanges
Ringkasan
create
delete
get
getIamPolicy
list
listSubscriptions
patch
setIamPolicy
langganan
testIamPermissions
projects.locations.dataExchanges.listings
Ringkasan
create
delete
get
getIamPolicy
list
listSubscriptions
patch
setIamPolicy
langganan
testIamPermissions
projects.locations.dataExchanges.queryTemplates
Ringkasan
setujui
create
delete
get
list
patch
kirim
projects.locations.subscriptions
Ringkasan
delete
get
getIamPolicy
list
perbarui
revoke
setIamPolicy
Types
DiscoveryType
ListSharedResourceSubscriptionsResponse
Operasi
Referensi REST (v1beta1)
Resource REST
organizations.locations.dataExchanges
Ringkasan
list
projects.locations.dataExchanges
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
projects.locations.dataExchanges.listings
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
langganan
testIamPermissions
Types
AttributeContext
AuditConfig
Binding
DestinationDataset
FederatedAttributeStatus
GetIamPolicyRequest
GetResourceInfoRequest
LogType
MonitoredResource
OperationMetadata
Kebijakan
RefreshSubscriptionResponse
ResourceInfo
SetIamPolicyRequest
SharedResourceType
State
SubscribeDataExchangeResponse
Berlangganan
TestIamPermissionsRequest
TestIamPermissionsResponse
Referensi API BigQuery Data Transfer Service
Library klien BigQuery Data Transfer Service
REST API BigQuery Data Transfer Service
Referensi REST
Resource REST
project
Ringkasan
enrollDataSources
projects.dataSources
Ringkasan
checkValidCreds
get
list
projects.locations
Ringkasan
enrollDataSources
get
list
unenrollDataSources
projects.locations.dataSources
Ringkasan
checkValidCreds
get
list
projects.locations.transferConfigs
Ringkasan
create
delete
get
list
patch
scheduleRuns
startManualRuns
projects.locations.transferConfigs.runs
